VLOOKUP error with direct Table name

[LightSpeeds]

=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 · Accepted solution]

@LightSpeeds 

Use INDIRECT:

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

[#3]

thanks mate! it worked.