Hello. I'm trying to do a hlookup but it's returning a ref error. Please help. Spreadsheet attached. Thanks.
Hello. I'm trying to do a hlookup but it's returning a ref error. Please help. Spreadsheet attached. Thanks.
Try this
=HLOOKUP(C8,C3:O4,2,0)
Or
=LOOKUP(2,1/(C3:O3=C8),C4:O4)
Or
=INDEX(C4:O4,MATCH(C8,C3:O3,0))
Or
=SUMPRODUCT((C3:O3=C8)*(C4:O4))
Or
=SUMIF(C3:O3,C8,C4:O4)
Last edited by AlKey; 05-01-2015 at 05:10 PM.
If you like my answer please click on * Add Reputation
Don't forget to mark threads as "Solved" if your problem has been resolved
"Nothing is so firmly believed as what we least know."
--Michel de Montaigne
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks