Results 1 to 4 of 4

Thread: What formula should i use for matching table?

  1. #1
    Neophyte archie's Avatar
    Join Date
    Jul 2018
    Posts
    2
    Articles
    0
    Excel Version
    2010

    What formula should i use for matching table?



    Register for a FREE account, and/
    or Log in to avoid these ads!

    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
    Attached Files Attached Files

  2. #2
    Acolyte Azumi's Avatar
    Join Date
    Jan 2014
    Location
    Indonesia
    Posts
    29
    Articles
    0
    Excel Version
    2010
    Hope this helps
    Attached Files Attached Files

  3. #3
    Super Moderator AliGW's Avatar
    Join Date
    Nov 2015
    Location
    Ipswich, Suffolk, England
    Posts
    963
    Articles
    0
    Excel Version
    Office 365 Subscription
    For the benefit of all, please explain the solution offered in your post as well as the attachment. Thanks.
    Ali
    Enthusiastic self-taught user of MS Excel!

  4. #4
    Neophyte archie's Avatar
    Join Date
    Jul 2018
    Posts
    2
    Articles
    0
    Excel Version
    2010
    Quote Originally Posted by Azumi View Post
    Hope this helps
    Hi Azumi,

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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •