I have multiple lookup tables, however the lookup information is identical in many circumstances, however I want use a dropdown list to dynamically change the lookup table, e.g.

=vlookup(cell_ref,choice of range from list, column_number)

Is this possible?

to clarify, lets suppose I have 4 lookup ranges named, north, east, south, west.

I want to be able to use a dropdown list to select the lookup range, and then all the applicable lookup formulas will then use than lookup range.

Welcome to the Board!

Something like this?

Hope that helps,

Smitty

Many thanks for the welcome and help. I think we are on the way, here is an example that perhaps defines better what I want to do

hmm didnt take file