Over Nesting of Functions

[~WindzStriker~]

Hi,

I've a problem doing up a formula for a cell based on different conditions to look up fixed values from different months.

The formula is written as follows;

'=IF(A32='ASIA'!$Z$42,VLOOKUP(A33,JUN,4,FALSE),IF(A32='ASIA'!$Z$43,VLOOKUP(A33,JUN,3,FALSE),IF(A32='ASIA'!$Z$35,VLOOKUP(A33,MARSEP,3,FALSE),IF(A32='ASIA'!$Z$54,VLOOKUP(A33,DEC,3,FALSE),IF(A32='ASIA'!$Z$56,VLOOKUP(A33,DEC,5,FALSE),IF(A32='ASIA'!$Z$39,VLOOKUP(A33,MARSEP,5,FALSE),IF(A32='ASIA'!$Z$50,VLOOKUP(A33,JUN,5,FALSE),IF(A32='ASIA'!$Z$55,VLOOKUP(A33,DEC,4,FALSE),0))))))))

There is a indication (The specified formula cannot be entered becaused it uses more levels of nesting than are allowed in the current file format) prompted by excel.

The formulation worked when i removed the additional loop highlighted in bold.

I am required to do 20 lookups .

Anyone able to help advise ????

Thank you so much in advance!!

[ajryan88]

Can you please upload your workbook so that I can attempt to develop an alternative working formula.

In this workbook, you will also need to clearly explain what the results of the formula should look like, giving some examples too.

Thanks

[wenqq3]

http://www.techonthenet.com/excel/macros/if_custom.php
Check this, how to make IF more than 7.