Thread: VLOOKUP using a tab name to reference the lookup range
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson Dave Peterson is offline
external usenet poster
  
Posts: 35,218
Default 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
Reply With QuoteReply With Quote