HLOOKUP: specify table array in a cell

[Melanie]

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

 

[T. Valko]

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)

 

[Melanie]

oops I mean different workbook. Is there any way of not having that other
workbook open?

Thanks

 

[T. Valko]

This thread describes some alternatives:

http://groups.google.com/group/microsoft.public.excel.worksheet.functions/msg/ac443753560f0075