Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
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 |