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?
=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?