Forum Discussion
HOW TO: "If cell contains specific text then return specific text"
What I really Want is: Depending on Which Store Name I enter into the 1st cell, I want a particular % entered into the 2nd cell. The second Cell is already formatted to be a percent with no decimals.
So if the1st Cell has "Lowes" in it. I want the 2nd cell to end up with "15%" in it.
And want to be able to ad additional Stores, with their perspective % as well.
So Lowes = 15%
Leonards = 10%
amazon = 12%
2 Replies
This sort of thing?
If you'd like more info I've done a couple of videos:
How to do an INDEX MATCH: https://www.youtube.com/watch?v=cT6K8Gz97PE&t=137s
How to do a drop down list : https://www.youtube.com/watch?v=eNmfHsBIyIY&t=24s
In the attached file, the formula in Sheet2!B2 is:
=VLOOKUP(A2,
StorePercent,
2,0)Note that StorePercent is defined as:
=Sheet1!$A$2:INDEX(Sheet1!$B:$B,COUNTA(Sheet1!$A:$A))
You can add stores and their corresponding percent in Sheet1 without any required modification in VLOOKUP in Sheet2!B2.
Please test it and inform me of your thoughts thereon.
