If Then or Array Condition Help

[John]

I am attempting to fill in a value in a cell based on a condition. IE if cell B2 says Jan then enter value X, if cell B2 says Feb then enter Y, etc. I would like to check for 17 different values in cell B2.

Excel has a limit of 7 nested if statements. How else can I do this

Thanks

Joh
Novice Excel User

 

[Frank Kabel]

Hi John
have a look a´t VLOOKUP. Create a separate range/worksheet with your
conditions and return values. Let sya you use a separate sheet named
'lookup' with the following design:
A B
Jan X
Feb Y
....

now use VLOOKUP:
=VLOOKUP(B2,'lookup'!$A$1:$B$17,2,0)

Frank

 

[Frank Kabel]

Hi John
should work. You only have to make sure, that both (your lookup value
and the entries in the lookup range) are identical.

Frank