What formula should i use for matching table?

[archie]

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

[Azumi]

Hope this helps

[AliGW]

For the benefit of all, please explain the solution offered in your post as well as the attachment. Thanks.

[archie]

Hope this helps

Hi Azumi,

Thank you very much! it works for me. Really appreciate!