Can an HLookup Array be a reference from another cell?

  • Thread starter Thread starter Matthew
  • Start date Start date
M

Matthew

I am using a combo box to automagically return a value to
an index cell at A1 on my worksheet and it works as
advertised.

What I need to do is use that value (door, wall, window)
within the hlookup formula as the array reference to pull
the proper value out of the correct array. (door, wall,
window)

I would like to use =hlookup(qty,array,2,false)

where "qty" is a reference to a cell (L1) where the
quantity required is specified and where "array" is the
name of the array returned by the index function and
placed in cell A1.

It all works manually, the qty reference works within
hlookup, but the use of a reference cell at the
table_array position returns a #N/A. I have tried using
the cell reference A1, 'A1', $A$1, {A1} all without
success and I have tried naming A1 as 'array' (w/o the 's)
and using =hlookup(qty,array,2,false) without success.
The qty reference works for lookup_value but the array
reference does not for table_array.

Any help?????

Thanks,

matthew
 
Back
Top