Hi, I'm having a really hard time with this one.

Here is the current formula:
=IF(ISNA(VLOOKUP($B$8,'sheet1'!$I:$AH,11,FALSE)),I F(ISNA(VLOOKUP($B$8,sheet2!$I:$AH,11,FALSE)),IF(IS NA(VLOOKUP($B$8,sheet3!$I:$AH,11,FALSE)),IF(ISNA(V LOOKUP($B$8,sheet4!$I:$AH,11,FALSE)),IF(ISNA(VLOOK UP($B$8,sheet5!$I:$AH,11,FALSE)),IF(ISNA(VLOOKUP($ B$8,sheet6!$I:$AH,11,FALSE)),"none",VLOOKUP($B$8,s heet6!$I:$AH,11,FALSE)),VLOOKUP($B$8,sheet5!$I:$AH ,11,FALSE)),VLOOKUP($B$8,sheet4!$I:$AH,11,FALSE)), VLOOKUP($B$8,sheet3!$I:$AH,11,FALSE)),VLOOKUP($B$8 ,sheet2!$I:$AH,11,FALSE)),VLOOKUP($B$8,sheet1!$I:$ AH,11,FALSE))

It looks up a code that can appear more than once in column I and returns the corresponding date in column 11. It will return 1st date in which the code appears. I would like to change it to return the last date in which the code appears....

Yikes!
Jill