Hi,

You don't need indirect for this

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

Mike

"BNT1 via OfficeKB.com" wrote:

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

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...excel/200902/1