Referring at an Array in different worksheet

[Holbeck_Ghyll]

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.

[ragulduy]

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

[Holbeck_Ghyll]

That's great, thanks very much!