Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
vlookup where sheet name=cell value
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
vlookup where sheet name=cell value
Thanks P.
I fiddled about with it and got this to work: =VLOOKUP(A2,INDIRECT("'"&I2 & "'!$A$2:$C$260"),3,FALSE) I also tried to make it tidier. The other sheets are named after people and the I:I column also refers to the same people names. I tried creating a named Range called "Resource" =Left(I2,5) to pick up the first five letters of the persons name/sheetname and I created dynamic ranges with the same names for the ranges in the other sheets. I thought I would be able to call "Resource" to refer to the different ranges, but, I get a volatile result with the following formulae. =VLOOKUP(A3,INDIRECT(Resource),3,FALSE) "papou" wrote: 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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
take sheet name from a cell in VLOOKUP | Excel Worksheet Functions | |||
Can I find a cell with vlookup formula on sheet | Excel Worksheet Functions | |||
Vlookup a part of a cell value in another sheet | Excel Worksheet Functions | |||
Vlookup a part of a cell value in another sheet | Excel Worksheet Functions | |||
Using a cell reference of a sheet in Vlookup | Excel Worksheet Functions |