Use A Tab Name As Part Of A VLOOKUP Formula

TkdKidSnake

Board Regular
Joined
Nov 27, 2012
Messages
235
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


Thanks in advance
 

Some videos you may like

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
Joined
Nov 27, 2012
Messages
235
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


Thanks in advance
 

Watch MrExcel Video

Forum statistics

Threads
1,099,647
Messages
5,469,922
Members
406,674
Latest member
MrSTruct

This Week's Hot Topics

Top