where A1 would contain the info on my
range of cells in a different notebook.

What do you mean by: in a different notebook?

You can try it like this but if a different notebook means a different
workbook (file) then that workbook (file) must be open for this to work.

=HLOOKUP("ABC",INDIRECT(A1),5,0)

--
Biff
Microsoft Excel MVP


"Melanie" wrote in message
...
I am looking to specify the range of cells for the table_array in a cell.

For example:
=HLOOKUP("ABC", A1, 5, 0)
where A1 would contain the info on my range of cells in a different
notebook.

How would I do this?
Thanks