SOLVED

VLOOKUP error with direct Table name

New Contributor

=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
best response confirmed by Sergei Baklan (MVP)
Solution

@LightSpeeds 

Use INDIRECT:

 

=VLOOKUP(G10,INDIRECT(O10),P10,FALSE)

thanks mate! it worked.