Lookup_Array name created by concatenation

[Mrs Doubtfire]

Is it possible to create an array name which is the result of a concatenation of 3 variables input by the user to be used to extract data from an array using a vlookup command?

There are 72 arrays with defined names. The user will enter 3 variables into 3 different cells from which the concatenation will be created. There is data validation to ensure that the user enters only valid entries. Once the array name is created from the concatenation, it will be used in a vlookup command to extract data from one of the 72 arrays based on the combination of values entered by the user.

clear as mud?

[Greg M]

Hi there,

Take a look at the attached workbook and see if it gets you moving in the right direction.

It uses the INDIRECT function in Cell G19 to identify the named range "tblAaBbCc" from the concatenated values of the variables stored in Cells D19:F19, i.e.:

Please Login or Register  to view this content.

Hope this helps - please let me know how you get on.

Regards,

Greg M

[Mrs Doubtfire]

Your solution worked beautifully; as a result, I was able to rewrite a complex nested IF statement that filled 3 pages of a Word document and now only takes about 4 sentences. Thanks so much.

[Greg M]

Hi again,

Many thanks for your feedback and also for the Reputation increase - much appreciated

You're very welcome - glad I was able to help.

Best regards,

Greg M