What formula should i use for matching table?

A

archie

New member
Joined
Jul 11, 2018
Messages
2
Reaction score
0
Points
0
Excel Version(s)
2010
Hi Ppls,

Can someone help me? in what formula should I use for the table attached.
I wanted to get the value for column D. (descending order)
Reference is column b:c.
look value: column E

thanks all
 

Attachments

  • sample.xlsx
    8.6 KB · Views: 14
Hope this helps
 

Attachments

  • sample.xlsx
    9.8 KB · Views: 16
For the benefit of all, please explain the solution offered in your post as well as the attachment. Thanks.
 
You must log in or register to reply here.
Back
Top