HLOOKUP: specify table array in a cell
 

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

HLOOKUP: specify table array in a cell
 

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

HLOOKUP: specify table array in a cell
 

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

Thanks
"T. Valko" wrote:

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

HLOOKUP: specify table array in a cell
 

This thread describes some alternatives:

http://groups.google.com/group/micro...443753560f0075

--
Biff
Microsoft Excel MVP


"Melanie" wrote in message
...

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

Thanks
"T. Valko" wrote:

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