Dear all,

Does anyone know how to solve the following problem:-

I am using the IF function, and I have more than 9 criterias. Whereas the
Excel 2003 is only allowed for 7 nesting functions. Instead of using the
Excel 2007, what other functions can be applied?

I wanna use the lookup functions. However, my worksheet setup is with the
criterias on the horizontal rows and vertical columns, hence it is hard to
use the vlookup and hlookup together.

Please advise if anyone knows how to solve.

Thanks alot in advanced.

Cheers

Sounds like you want a two dimensional lookup

http://j-walk.com/ss/excel/usertips/tip020.htm
http://www.cpearson.com/excel/lookups.htm#DoubleLookup


"Tan" wrote:

Dear all,

Does anyone know how to solve the following problem:-

I am using the IF function, and I have more than 9 criterias. Whereas the
Excel 2003 is only allowed for 7 nesting functions. Instead of using the
Excel 2007, what other functions can be applied?

I wanna use the lookup functions. However, my worksheet setup is with the
criterias on the horizontal rows and vertical columns, hence it is hard to
use the vlookup and hlookup together.

Please advise if anyone knows how to solve.

Thanks alot in advanced.

Cheers