Vlookup
 

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

Vlookup
 

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

Vlookup
 

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?

Mike H wrote:
Hi,

You don't need indirect for this

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

Mike

Hi

[quoted text clipped - 11 lines]

Regards

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

Vlookup
 

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

BNT1 wrote:
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]

Regards

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