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?