Making Text Appear in a cell based on text in 2 other cells

[NSimp216]

Hi all,

I am a super noob to this kinda stuff and need some help.

I am trying to get text to appear in a cell based on the text in 2 other cells.

I am using this to match performance (A) and potential (B) scores that I have entered in a drop down to populate the value of (C) at the end of the row.


A + B = C
Low + Low = Reasign
Low + Med = Valued
Low + High = Potential
Med + Low = Acceptable
Med + Med = Middle
Med + High = Rising Star
High + Low = Struggle
High + Med = Potential Star
High + High = Star

The values of A and B will come from different cells and I hope to put it in a new cell.

So if i picked Low in the first column and the Med in the second column it would tell me that it is Valued

[Pete_UK]

You can set up a little table somewhere (e.g. in X1:Y9) with these entries:

LowLow ..... Reasign
LowMed ..... Valued
LowHigh ..... Potential
MedLow ..... Acceptable
MedMed ..... Middle
MedHigh ..... Rising Star
HighLow ..... Struggle
HighMed ..... Potential Star
HighHigh ..... Star

then assuming your drop-downs are in A1 and B1, put this formula in C1:

=IF(A1&B1="","",IFERROR(VLOOKUP(A1&B1,$X$1:$Y$9,2,0),"entry error"))

Then copy down as required.

Hope this helps.

Pete

[NSimp216]

Holy Cow Pete - I don't know how or why that worked but it did...thank you very very much!!!