Hi,
I have a "IF" statement that does the following
=IF(L2=C2,B2,IF(L2=C3,B3,IF(L2=C4,B4,.......... - I cannot use this formula because I have more than 64 nested values
So, If I type a particular text in Column L, Col F should fill up with the corresponding value - from the info range given in Col B.
In other words, if I type a name of a County in a column, the previous column on left should fill up with the name of the State in which it is found - from the range of States I have in a different column.
If this question makes sense to anyone, please respond - it could either be a "If" statement or "Macro".
Only problem is, I have more than 64 nested if's - so if you can find another function or make relevant suggestions, that would be great.
Thanks.
2007-10-15
05:59:13
·
4 answers
·
asked by
NumJunkie
1
in
Programming & Design