G Guest Dec 15, 2004 #1 since excel has a limit of 7 nested ifs and someone i know needs to do 12 nested ifs is there a way to do this
since excel has a limit of 7 nested ifs and someone i know needs to do 12 nested ifs is there a way to do this
B Bob Phillips Dec 15, 2004 #2 Depends upon what the data looks like, but you should be able to use LOOKUP or VLOOKUP where the test values and lookup values are defined in a table. -- HTH RP (remove nothere from the email address if mailing direct)
Depends upon what the data looks like, but you should be able to use LOOKUP or VLOOKUP where the test values and lookup values are defined in a table. -- HTH RP (remove nothere from the email address if mailing direct)
