Hi

For a while now I've not been able to write a formula that looks up against a variable named range - I need some help!

For example, say I have 2 named ranges, Area1 and Area2, both 5x5. I also have an input cell, A1, and an output cell, B1

What I want to be able to do is for the user to type in to cell A1 the range they want to look up against (eg "Area2") and then for the output cell (B1) to return a certain cell in that range (eg 2nd row and 3rd column)

I've tried VLOOKUP, INDEX and others but they all seem to need a fixed range to look up aganist, and cant take a variable argument.

Any help much appreciated!

Thanks