Lookup & named cells

  • Thread starter Thread starter Guest
  • Start date Start date
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?
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

HLOOKUP Formula Error 1
OFFSET and LOOKUP Error 1
if function help 5
cell reference from hlookup 4
Lookup Problem 3
Referen to cell on other sheet not working 2
HLOOKUP 2
Using IF to reference two cells 3

Back
Top