Forum Discussion
LightSpeeds
Jul 12, 2022Copper Contributor
VLOOKUP error with direct Table name
=VLOOKUP(G10,O10,P10,0)
so cell O10 contains the Table name and P10 contains the column number I need to look for.
O10=VLOOKUP(CONCATENATE(U10,W10,X10,Y10),TableMap,2,FALSE)
This way I search for the sub-table I need to look for. TableMap contains the table names. TableMap is a table of table names.
P10=VLOOKUP(CONCATENATE(U10,W10,X10,Y10),TableMap,3,0)
this way it calculates the column number I need to look for in the table found from TableMap
O10 and P10 work individually but sadly, when I nest them in =VLOOKUP(G10,O10,P10,0) they don't work sadly.
i get #N/A error
please help if you can
2 Replies
- LightSpeedsCopper Contributorthanks mate! it worked.