Thread: VLOOKUP using the act shts tab name as a reference for the table_a
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
timmulla timmulla is offline
external usenet poster
  
Posts: 46
Default VLOOKUP using the act shts tab name as a reference for the table_a
Hello, I was wondering if somebody could help me with a VLOOKUP formula.

VLOOKUP(A2,'MHP 01-03-2007 '!A13:T144,12,FALSE)

Is there a way to adjust the formula above so that the MHP 01-03-2007
portion of the above formula will reference the active sheets tab name
instead of hard coded text?

any help would be appreciated.

thanks,

Tim



--
Regards,

timmulla
Reply With QuoteReply With Quote