VLOOKUP using a tab name to reference the lookup range
 

--
Regards,

timmulla

VLOOKUP using a tab name to reference the lookup range
 

I don't know what you are asking.
what do you want to do?

"timmulla" wrote:


--
Regards,

timmulla

VLOOKUP using a tab name to reference the lookup range
 

Maybe something like this...

With the worksheet name in A1 of the worksheet with the formula:

=vlookup(a2,"'" & $a$1 & "'!a:e",5,false)





timmulla wrote:

--
Regards,

timmulla

--

Dave Peterson

VLOOKUP using a tab name to reference the lookup range
 

Oops! I had a typo:

=vlookup(a2,indirect("'" & $a$1 & "'!a:e"),5,false)

timmulla wrote:

--
Regards,

timmulla

--

Dave Peterson