Forum Discussion

LightSpeeds's avatar
LightSpeeds
Copper Contributor
Jul 12, 2022
Solved

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