Thread: Using a cell reference of a sheet in Vlookup
View Single Post
  #2   Report Post  
John Michl
 
Posts: n/a
Default
You can use the INDIRECT function to piece together your formula. Try
the following:

A10 = vlookup(D10,indirect(A1)&"!A:D",4,false)

- John Michl

Reply With QuoteReply With Quote