Dynamic table_array value for Vlookup function

[TheRox]

Alright, I am trying to figure out if the following is possible.
I have in F2 of the attached excel file tried to get the table_array value for the vlookup function dynamic. The input for the table_array is in the column title (line 1). I cannot make it work despite my research.

Can somebody look into it to let me know what is wrong in my attempt?
Column D and E are the expected outcome (function not dynamic), column F is my vain attempt...

Thanks very much in advance for your attention.

Best,

Rox

[Glenn Kennedy]

Use this, copied across and dnown:

=VLOOKUP($C2,INDIRECT("'"&F$1&"'!A1:C300"),3,FALSE)

Don't use whole column references inside INDIRECT. Calculating 1,000,000 rows for each column will be sooo sloooow.

[Glenn Kennedy]

With your file...

I have just noticed you're in France. You may need ; instead of , in the formula.

[TheRox]

OK well noted!! working perfect!! Thank you so much Glenn!!

[TheRox]

Merci Glenn!!!

[Glenn Kennedy]

You're welcome and thanks for the Rep.