Vlookup question

[senan_g]

Hi folks

I am wondering is it possible to use a variable value for the table_array input on a vlookupargument.

So for instance the vlookup argument is
=vlookup(lookup_value, table_array, col_index_num, [range_lookup])

and I would like to have one of several arrays used depending what is selected in a drop down box.

Can this be done or could someone suggest a different way of doing it...

Thanks!

senan_g

[abousetta]

Hello and welcome to the Forum,

Maybe a simple example like the attachment is what you are looking for. If not, please post back with a dummy workbook so we can see what the actual situation looks like.

Good luck.

abousetta

[senan_g]

Hi abousetta

I can use the dropdown for the variable "lookup_value" but I am not sure how to use a variable value for the "table_array" input. I have reworked your template a little bit to add a second array, now I would like to return a value that looks at one of two possible arrays.

Does my question make sense now?

Thanks for your help

senan_g

[abousetta]

Hi,

The new formula would be:

Please Login or Register  to view this content.

D3 would contain the first dropdown to tell the formula what the value to lookup is and D6 woudl contain the named range (in this case I named them Array1 and Array2).

Good luck.

abousetta

[senan_g]

Thanks - that really helps. Sorry about the delay in coming back to you!
Senan_g