Use A Tab Name As Part Of A VLOOKUP Formula

[TkdKidSnake]

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

=VLOOKUP(U5,'SCORING BY MONTH'!A4:B203,2,FALSE)

And in cell U5 I have the following:

=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

 

[TkdKidSnake]

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

=VLOOKUP(U5,'SCORING BY MONTH'!A4:B203,2,FALSE)

And in cell U5 I have the following:

=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