JasonSGRankin
New Member
- Joined
- Jun 23, 2003
- Messages
- 2
I am looking to use a Vlookup function with a named range. The problem is that users have the option of selecting a "letter" eg W from a validation list. Once a letter is selected it determines, via a lookup the name of the "Named Range", ie EG;
If the user selects W, then the named range will be "ACT1". the value "ACT1" will be placed in a destination cell. The vlookup function will then lookup a value in the selected named range being ACT1. Therefore is the destination cell that the "ACT1" was placed in was [D1], then the formula would read as:
VLOOKUP(lookup_value,[D1],4,FALSE)
The result I get is #N/A. I don't know how to get the formula to realise that it needs to lookup the value in the range specified by the name in cell [D1]. Is there a solution to this?
Please also not that the named range "ACT1" is on a seperate worksheet tab within the same workbook.