Hlookup row 5
 

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.

Hlookup row 5
 

Clinton;431024 Wrote:
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.

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

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


--
barry houdini
------------------------------------------------------------------------
barry houdini's Profile: http://www.thecodecage.com/forumz/member.php?userid=72
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=119704