I don't think both of your formula work at all, unless you have a define name
"white" of your data range not just on cell C6. What is your data table look
like?


"Eddie" wrote:

I am trying to use a named cell group as the table array in a lookup
function. It works when I type the name into the function, but not when I
have a cell reference to it, ie.

it works as =HLOOKUP(E14,white,4)

but not as
cell C6 contains word white.
=HLOOKUP(E14,C6,4)

Any suggestions?

Sorry I was not clear enough in my question.

I have a defined group of cells called white. I want the lookup formula to
use the cell C6, not the name, so if I vary what is written in cell C6 it can
look up other named groups eg red or blue.

Does this make more sense?

Eddiw

"Teethless mama" wrote:

I don't think both of your formula work at all, unless you have a define name
"white" of your data range not just on cell C6. What is your data table look
like?


"Eddie" wrote:

I am trying to use a named cell group as the table array in a lookup
function. It works when I type the name into the function, but not when I
have a cell reference to it, ie.

it works as =HLOOKUP(E14,white,4)

but not as
cell C6 contains word white.
=HLOOKUP(E14,C6,4)

Any suggestions?

=HLOOKUP(A14,INDIRECT(C6),4)


"Eddie" wrote:

Sorry I was not clear enough in my question.

I have a defined group of cells called white. I want the lookup formula to
use the cell C6, not the name, so if I vary what is written in cell C6 it can
look up other named groups eg red or blue.

Does this make more sense?

Eddiw

"Teethless mama" wrote:

I don't think both of your formula work at all, unless you have a define name
"white" of your data range not just on cell C6. What is your data table look
like?


"Eddie" wrote:

I am trying to use a named cell group as the table array in a lookup
function. It works when I type the name into the function, but not when I
have a cell reference to it, ie.

it works as =HLOOKUP(E14,white,4)

but not as
cell C6 contains word white.
=HLOOKUP(E14,C6,4)

Any suggestions?