Hlookup row 5

C

Clinton

i need a formula to lookup a value in row 5 and return the value in row 1.
As far as i have discovered it can only lookup row 1 and return a result for
cells below.
Any help would be appreciated.
 
B

barry houdini

Clinton;431024 said:
i need a formula to lookup a value in row 5 and return the value in ro
1.
As far as i have discovered it can only lookup row 1 and return
result for
cells below.
Any help would be appreciated.
Click to expand...

You can use an INDEX/MATCH construction, e.g. if lookup value is in B3

=INDEX(1:1,MATCH(B3,5:5,0)
 

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, LOOKUP & MATCH doesn't work. Seems not right. 1
Hlookup 0
Drop down list control value in vba 2
Newbie Help - IF Yes No Function 0
HLOOKUP & VLOOKUP Combinded 4
Repeating a row other than the 1st row as the header row in a table from next page 1
hlookup value within a range 4
Mail Merge Switch - Dollars to Words 0

Top