Is it possible....

[pholt33]

to put a vlookup inside of a vlookup? Here is my original formula that works just fine:
=IF(ISERROR(VLOOKUP(C2,'L:\ACM\Departments\Performance\Incentive Comp\2008\April\[Acqdispic.xls]MGR-IC'!$E:$X,8,FALSE)),0,(VLOOKUP(C2,'L:\ACM\Departments\Performance\Incentive Comp\2008\April\[Acqdispic.xls]MGR-IC'!$E:$X,8,FALSE)))/100

What I want to do is set up another vlookup that would automatically change the month portion of the above formula based on an input cell. So if someone puts 5/31/2008 in a cell, a =month() formula returns "5", which tells another vlookup formula to find 5 in the list of months and return May. I want that May to replace the April in the formula up above. I have everything working except that last part where it changes the link reference.

Is this possible to do?

 

[xld]

You would normally do that by using INDIRECT,

INDIRECT("'L:\ACM\Departments\Performance\Incentive Comp\2008\"&TEXT(A1,"mmmm"&"\[Acqdispic.xls]MGR-IC'!$E:$X")

but that won't work with a closed workbook, so you will need to get and use Laurent Longre's MOREFUNC dll or Harlan Grove's Pull function.