# Use A Tab Name As Part Of A VLOOKUP Formula

#### TkdKidSnake

##### Board Regular
Hi all,

I am trying to use a tab name as part of a VLOOKUP formula however what I have so far returns #N/A

VLOOKUP Formula
Code:
``=VLOOKUP(U5,'SCORING BY MONTH'!A4:B203,2,FALSE)``
And in cell U5 I have the following:
Code:
``=MID(CELL("filename",A1),FIND("]",CELL("filename",A1))+1,255)``
In this instance this would return the sheet value / name in a range from 1-200

The the tab "Scoring By Month"
Column A (4 to 203) has the rows numbered 1-200
Column B (4 to 203) has the names and this is the detail I want the formula to return

I'm not sure why this isn't working so any help you can provide

### Excel Facts

Did you know Excel offers Filter by Selection?
Add the AutoFilter icon to the Quick Access Toolbar. Select a cell containing Apple, click AutoFilter, and you will get all rows with Apple

#### TkdKidSnake

##### Board Regular
I found a work around for this by putting a letter in front of the number in the sheet name so 1 would become A1 and as long as the data sheet is numbered the same it works - not ideal but a solution.

Hi all,

I am trying to use a tab name as part of a VLOOKUP formula however what I have so far returns #N/A

VLOOKUP Formula
Code:
``=VLOOKUP(U5,'SCORING BY MONTH'!A4:B203,2,FALSE)``
And in cell U5 I have the following:
Code:
``=MID(CELL("filename",A1),FIND("]",CELL("filename",A1))+1,255)``
In this instance this would return the sheet value / name in a range from 1-200

The the tab "Scoring By Month"
Column A (4 to 203) has the rows numbered 1-200
Column B (4 to 203) has the names and this is the detail I want the formula to return

I'm not sure why this isn't working so any help you can provide