View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
papou[_4_] papou[_4_] is offline
external usenet poster
 
Posts: 110
Default vlookup where sheet name=cell value

Hello Dylan
Use INDIRECT to build your reference ie:

=VLOOKUP(A2,INDIRECT(I2 & "'!$A$2:$A$260"),3,FALSE)

HTH
Cordially
Pascal

"DDawson" a écrit dans le message de
news: ...
Can you help me to set up a Vlookup to another sheet where the sheet name
is
the taken from the cell value in cell (I2). For example:

=VLOOKUP(A2,'(I2)'!$A$2:$A$260,3,FALSE)

Dylan Dawson