G
Guest
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?
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?