Look in HELP for the INDIRECT() function

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"mr_teacher" wrote in message
...
|
| 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
|