lookup across sheets

Hi Guys,

Just to start by thanking this forum for the help.

Just wanted to ask how I find the adjacent value. I have this formula, but when I add another IF condition, its not accepted. (maybe the formula is too long for excel?).

=IF((K29=Jan!$B$34),Jan!$D$34,IF((K29=Feb!$B$31),Feb!$D$31,IF((K29=Mar!$B$33),Mar!$D$33,IF((K29=April!$B$32),April!$D$32,IF((K29=May!$B$34),May!$D$34,IF((K29=June!$B$32),June!$D$32,IF((K29=July!$B$33),July!$D$33,IF((K29=August!$B$34),August!$D$34,""))))))))

What this does is its comparing K29 with values on other tabs, and then if it matches, its populating the cell with the date adjacent to value on the tab.

So for example its saying if K29 = May.B34, then put in May.D34 - which is a date.

Thank you in advance
DrChris

i thought you could only nest upto 7 if's?????

Hi Chippy

Cheers for the reply

Indeed it does, but adding another IF condition (for september for example), doesnt seem to work!

=IF(K29=Jan!$B$34,Jan!$D$34,IF(K29=Feb!$B$31,Feb!$D$31,IF(K29=Mar!$B$33,Mar!$D$33,IF(K29=April!$B$32,April!$D$32,IF(K29=May!$B$34,May!$D$34,IF(K29=June!$B$32,June!$D$32,IF(K29=July!$B$33,July!$D$33,IF(K29=August!$B$34,August!$D$34,IF(K29=Sept!$B$31,Sept!$D$31,"")))))))))

Any ideas?

JustinBram: Looks like its 8

Thing is, I need to do that for every month: i.e 12 IFs!