Nesting Functions
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 |
Nesting Functions
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 |
All times are GMT +1. The time now is 09:29 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com