Home |
Search |
Today's Posts |
#1
|
|||
|
|||
VLOOKUP
Hi, I need some help with a Vlookup that im trying to make for a list of
"table array" names that i have in another column. The function needs to search the name of the table to work properly but it can not recognize the table name as a text or function constant...Im doing this to avoid writting function by function the name that each one needs.... Column A Column B 1 =VLOOKUP(Day+E9;TBL_one;2;"FALSE") TBL_one 2 =VLOOKUP(Day+E9;TBL_two;2;"FALSE") TBL_two 3 =VLOOKUP(Day+E9;TBL_three;2;"FALSE") TBL_three 4 =VLOOKUP(Day+E9;TBL_four;2;"FALSE") TBL_four I have tried some ways to do it but still can not recognize the reference 1.) I have written the (x,y) position of the table name. =VLOOKUP(Day+E9;B1;2;"FALSE") B1=TBL_one ......didnt work 2) Making the name using TBL & name.....didnt work 3) Using the TEXT(B1) function worked but brings the name with double quotation marks ...as "TBL_one" and needs to come clean Any help would be really apreciated |
#2
|
|||
|
|||
"snake" wrote:
... =VLOOKUP(Day+E9;B1;2;"FALSE") B1=TBL_one ......didn't work You need to use INDIRECT .. Try this: =VLOOKUP(day+E9,INDIRECT(B1),2,0) where B1 contains: TBL_one Or, with commas replaced by semicolons to suit your settings: =VLOOKUP(day+E9;INDIRECT(B1);2;0) -- Rgds Max xl 97 --- Singapore, GMT+8 xdemechanik http://savefile.com/projects/236895 -- |
#3
|
|||
|
|||
THANKS 4 your time Max, it works perfect
"Max" wrote: "snake" wrote: ... =VLOOKUP(Day+E9;B1;2;"FALSE") B1=TBL_one ......didn't work You need to use INDIRECT .. Try this: =VLOOKUP(day+E9,INDIRECT(B1),2,0) where B1 contains: TBL_one Or, with commas replaced by semicolons to suit your settings: =VLOOKUP(day+E9;INDIRECT(B1);2;0) -- Rgds Max xl 97 --- Singapore, GMT+8 xdemechanik http://savefile.com/projects/236895 -- |
#4
|
|||
|
|||
Glad to hear that !
Thanks for the feedback .. -- Rgds Max xl 97 --- Singapore, GMT+8 xdemechanik http://savefile.com/projects/236895 -- "snake" wrote in message ... THANKS 4 your time Max, it works perfect |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Using single cell reference as table array argument in Vlookup | Excel Worksheet Functions | |||
VLOOKUP Limitations | Excel Worksheet Functions | |||
Have Vlookup return a Value of 0 instead of #N/A | Excel Worksheet Functions | |||
vlookup data hidden within worksheet | Excel Worksheet Functions | |||
Vlookup info being used without vlookup table attached? | Excel Worksheet Functions |