Hi I have 2 ranges of cells named data1 and data2. I want to use these ranges
in one lookup formula by use of a drop down box.

If I type directly into the lookup formula "data1" as the table array the
formula works. Is it possible for the table array name to come from the drop
down selection?

Have tried right(), cell("contents",) but they dont work.

Basically I want to have a page with the formula and inputs and all the data
on separate pages. These pages are related to a drop down box on the input
page.

Thanks
Hope that makes some kind of sense.