Thread
:
vlookup where sheet name=cell value
View Single Post
#
2
Posted to microsoft.public.excel.programming
papou[_4_]
external usenet poster
Posts: 110
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
Reply With Quote
papou[_4_]
View Public Profile
Find all posts by papou[_4_]