Vlookup question

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