Help please with Look function of equal or higher value
Reference to the attached Excel sheet.
I am looking for a formulas please to insert in cell D1 and E1 that look at the manual value entry in cell C1and compare it the cells rang from A2 to B7 looking for equal or higher value on B2-B7 and the display that value in cell D1 and the related TEMP figure in the same row in cell E1.
Example:
If I enter (3405) in cell C1, I would like see please (3424) in cell D1 and (26) in cell E1.
Try
D1
=INDEX($B$2:$B$7,MATCH($C$1,$B$2:$B$7,-1))
E1
=INDEX($A$2:$A$7,MATCH($C$1,$B$2:$B$7,-1))
Marcelo Branco
Thank you, It is almost what I am looking for; I would like please to have cells D1 and E1 blank when cell C1 is empty.
The given formulas reflect (3220) in cell D1 and (30) in cell E1 with cell C1 empty!
Last edited by Khaldon; 08-12-2013 at 02:26 PM.
TryOriginally Posted by Khaldon
D1
=IF(ISNUMBER($C$1),INDEX($B$2:$B$7,MATCH($C$1,$B$2:$B$7,-1)),"")
E1
=IF(ISNUMBER($C$1),INDEX($A$2:$A$7,MATCH($C$1,$B$2:$B$7,-1)),"")
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks