HLOOKUP: specify table array in a cell

  • Thread starter Thread starter Melanie
  • Start date Start date
M

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
 
where A1 would contain the info on my
range of cells in a different notebook.
Click to expand...

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)
 
oops I mean different workbook. Is there any way of not having that other
workbook open?

Thanks
 
Back
Top