Hi,

Anyone have any ideas if it is possible t find the range to look up in
a VLOOKUP formula by referencing a cell?

For example if I used the formula

=vlookup(a1,d1,1,false)

Where d1 would contain a value that is a named range such as Numeracy
etc that would refer to a spreadsheet elsewhere in the workbook?

Thanks for any help

Carl


--
mr_teacher
------------------------------------------------------------------------
mr_teacher's Profile: http://www.excelforum.com/member.php...o&userid=34352
View this thread: http://www.excelforum.com/showthread...hreadid=564849