Results 1 to 2 of 2

Thread: Display highest value related to a cell from a different sheet

  1. #1

    Display highest value related to a cell from a different sheet



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

    Hello,
    In the attached file on 'Sheet1', I have a customer number. And on Sheet 2 I have two columns - one that contains customer number and the other one that displays the probability of getting business from a customer.

    I want to display the highest value of probability related to a customer from Sheet 2 to cell B2 in Sheet 1. For the given example, the final result in cell B1 on Sheet 1 should be 43%.

    Can someone please help?
    Very much appreciate your help and support in advance.
    Attached Files Attached Files

  2. #2
    Conjurer CheshireCat's Avatar
    Join Date
    Dec 2011
    Location
    Victoria, Canada
    Posts
    121
    Articles
    0
    Excel Version
    Microsoft Excel 2013
    How about using this array formula:

    Code:
    =MAX(IF(A2=Sheet2!A2:A34,Sheet2!B2:B34,0))
    Confirm as an array formula with Ctrl-Shift-Enter.

    Cheers,

Posting Permissions

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