# 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

#### 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

1,078,462
Messages
5,340,456
Members
399,376
Latest member
Tresfjording

### This Week's Hot Topics

• Problem with Radio Button's format control
I am creating an employee evaluation template (a sample is below) Column A is the category Column B, C D, E and F will be ratings (unacceptable...
• Last Display on userform to a Listbox
[CODE=vba] lstdisplay.ColumnCount = 15 lstdisplay.RowSource = "A1:O600000" [/CODE] So when i do this it Displays everything on the sheet i am...
• Rename and move files to a new location
Dear all, I have an excel file with the following information. The actual file name is at column A but i want to rename it using the following...
• Help with True/False Formula
Hello! Am stumped how to fix this formula, in which my result returns 'True', but it should return False. =IF(AG2=True...
• Clear extra characters from a provided range of cells
Dear All, I have following code which gives me desired output to remove extra characters from a provided range. But it takes too much time when...
• Help with Current and highest streaks
Hi there, I've just joined the forum and this is my first post. I've already spent quite a bit of time searching the net and this forum for a...