Nested vlookup with varable tables!

[Dave Jones]

Can anyone help here, I am trying to lookup a value which is in one of 6 tables all of the same format but although I can look up the name of the table to look at it gets enclosed in quotes so that I get a #VALUE! error when it is embedded in the second vlookup.



=VLOOKUP(1,VLOOKUP(key,contextlook,3,FALSE),2,FALS E)

Table contextlook looks like

Key 1,value 1, value 2
key 2,value 1, value 2

All of the tables that may be value 2 then look

1, value a, value b, value c
2, value d, value e, value f

As you can see the idea being to extract initially value a from the relevant table found by the first vlookup
VLOOKUP(key,contextlook,3,FALSE) which gives the result "value 2" - because of the quotes the second vlookup errors!

How do I get this resolved?
I have tried using different methods where the value is a name and a cell range neither work!