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?