VLOOKUP with dynamic TABLEARRAY

[Viva]

Hi,

my current cell-definition is like this:
=VLOOKUP(B10;'Object-Reference Attributes'!$D$3:$J$550;3;FALSE)

Explanations:
Object-Reference Attributes --> this is the Excel-Tab, where the formula should search for matches
$D$3:$J$550 should be replaced with a value which can be changed on a central place in Cell 'Param'!A3 (Param is the name of the Tab)

e.g. in cell 'Param'!A3 the value $D$3:$J$550 will be available

So, my goal is, to change the VLOOKUP-Formula in a way, that the $D$3:$J$550-Part will be replaced with a dynamic lookup in cell 'Param'!A3

I tried to solve the problem with a INDIRECT-Function, but this doesn't work :

=VLOOKUP(B10; Concat(" 'Object-Reference Attributes'!"; INDIRECT('Param'!A3));3;FALSE)

Do you have an idea ? Thank you in advance

Frank

 

[Fluff]

Hi & welcome to MrExcel.
How about

=VLOOKUP(B10; indirect("'Object-Reference Attributes'!"&'Param'!A3);3;FALSE)

 

[Viva]

Hi & welcome to MrExcel.
How about

=VLOOKUP(B10; indirect("'Object-Reference Attributes'!"&'Param'!A3);3;FALSE)

Perfect. That works. Thank you

 

[Fluff]

You're welcome & thanks for the feedback.