Hi,

I have a table which is populated by using the values of 2 cells (selected from drop down boxes) as references for a combination of INDEX and MATCH functions. These functions search 2 columns in another worksheet, and produce a result from the third column.

What I now want to do is have a third drop down which changes the sheet the INDEX & MATCH functions search (the data is in the same format, but are different datasets). I've tried using INDIRECT in a variety of ways to define the array in the separate worksheet, but keep getting errors as it is wanting a single cell reference rather than an array. One effort looked like this (F3 was a cell which contained the name of the worksheet, Range A was a named range in the worksheet) -

INDIRECT("'" & F3 & "'!" & RangeA)

Anyone have any information on this? Any help really would be appreciated.