I'm new here, hoping that some expert out there can help me out.
I'm working with the following vlookup function:
=VLOOKUP($E$2,'[EXCELFILENAME.xls]Oct'!$A$12:$F$20,2)
But, instead of always looking at the worksheet Oct, I want to enter the name in another cell, and have the formula use whatever I enter.
For example, if I entered Dec, the function would go out and do the vlookup command in that worksheet.
The cell I enter the month in is $D$2. I thought it would be something like:
=VLOOKUP($E$2,'[EXCELFILENAME.xls]$D$2!$A$12:$F$20,2)
But, that doesn't work. It's looking for a worksheet called "$D$2", and not a worksheet that's the contents of cell $D$2, which is Oct, Dec, or whatever I enter.
Any and all comments are greatly appreciated.
Thanks,
Keith
Detroit, Michigan USA
Go Tigers!
I'm working with the following vlookup function:
=VLOOKUP($E$2,'[EXCELFILENAME.xls]Oct'!$A$12:$F$20,2)
But, instead of always looking at the worksheet Oct, I want to enter the name in another cell, and have the formula use whatever I enter.
For example, if I entered Dec, the function would go out and do the vlookup command in that worksheet.
The cell I enter the month in is $D$2. I thought it would be something like:
=VLOOKUP($E$2,'[EXCELFILENAME.xls]$D$2!$A$12:$F$20,2)
But, that doesn't work. It's looking for a worksheet called "$D$2", and not a worksheet that's the contents of cell $D$2, which is Oct, Dec, or whatever I enter.
Any and all comments are greatly appreciated.
Thanks,
Keith
Detroit, Michigan USA
Go Tigers!