Vlookup

[BNT1 via OfficeKB.com]

Hi

Trying to vlookup the tab name in "dates" sheet
In B1 i have

=RIGHT(CELL("filename",B1),2), giving me the 2 digit tab name

In C1, i have =Vlookup(B1,Dates!A1:A20,2,0), but keep getting #N/A. I have
also tried

=VLOOKUP(INDIRECT(B1),Dates!A1:B20,2,0), but get #REF!

Can anyone assist in getting the vlookup using the tab name?

Regards

 

[Mike H]

Hi,

You don't need indirect for this

=VLOOKUP(B1,Dates!A1:B20,2,0)

Mike

 

[BNT1 via OfficeKB.com]

thanks for the speedy response

Keep getting #N/A, yet when i type the tab name in B1, overwriting the
formula, it works a treat

any ideas?

Hi,

You don't need indirect for this

=VLOOKUP(B1,Dates!A1:B20,2,0)

Mike

Hi

[quoted text clipped - 11 lines]

Regards

 

[BNT1 via OfficeKB.com]

incidentally, the 2 digits showing in B1 are on the left of the cell, other
numbers in cells are on the right - this is not formated to the right t

thanks for the speedy response

Keep getting #N/A, yet when i type the tab name in B1, overwriting the
formula, it works a treat

any ideas?

Hi,

[quoted text clipped - 9 lines]