Hi,
Hope someone can help me, been looking around but can't find my answer or the answers I have found I can't get to work properly.
I'm using a vlookup formula to access another workbook and sheet, the other workbook contains 12 sheets JAN through DEC, and I want the vlookup formula to use cell info to access the specific sheet. So basically I would like the info from cell C1 to be used as the sheet name in the formula, the workbook name remains the same.
Here is my formula at the moment :
=IF(ISERR(VLOOKUP($C$1,'[ROSTER BOOK 2010.xls]MAR10'!$B$8:$AG$136,2,FALSE)),"",VLOOKUP($C$1,'[ROSTER BOOK 2010.xls]MAR10'!$B$8:$AG$136,2,FALSE))
Any help is much appreciated.
Carl
Hope someone can help me, been looking around but can't find my answer or the answers I have found I can't get to work properly.
I'm using a vlookup formula to access another workbook and sheet, the other workbook contains 12 sheets JAN through DEC, and I want the vlookup formula to use cell info to access the specific sheet. So basically I would like the info from cell C1 to be used as the sheet name in the formula, the workbook name remains the same.
Here is my formula at the moment :
=IF(ISERR(VLOOKUP($C$1,'[ROSTER BOOK 2010.xls]MAR10'!$B$8:$AG$136,2,FALSE)),"",VLOOKUP($C$1,'[ROSTER BOOK 2010.xls]MAR10'!$B$8:$AG$136,2,FALSE))
Any help is much appreciated.
Carl