Lookup & named cells
THANK YOU! YOU ARE A STAR!!
"Teethless mama" wrote:
=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?
|