+ Reply to Thread
Results 1 to 3 of 3

Get minimum value, and If two cells match from a row, return values from the consecutive 3

  1. #1
    Registered User
    Join Date
    07-18-2016
    Location
    Barcelona
    MS-Off Ver
    Mac Office 2010
    Posts
    2

    Get minimum value, and If two cells match from a row, return values from the consecutive 3

    Get minimum value, and If two cells match from a row, return values from the consecutive 3 columns.

    Here's a simple explanation of what I'm having trouble with
    I have a table with
    SUPPLIER A
    • F4: PRICES SUPPLIER A,
    • G4: SUPPLIER A NAME,
    • H4: LEAD TIME SUPPLIER A,
    • I4: BRAND SUPPLIER A

    SUPPLIER B
    • J4: PRICES SUPPLIER B,
    • K4: SUPPLIER B NAME,
    • L4: LEAD TIME SUPPLIER B,
    • M4: BRAND SUPPLIER B

    SUPPLIER C
    • N4: PRICES SUPPLIER C,
    • O4: SUPPLIER C NAME,
    • P4: LEAD TIME SUPPLIER C,
    • Q4: BRAND SUPPLIER C


    On the first Table I need to get the SMALLEST price provided by the 3 suppliers, and save on the COLUMN MINUMUM PRICE B4:
    B4: The smallest price from the 3 suppliers
    C4: The consecutive 2nd column from the supplier selected with the SUPPLIER NAME (The name of the supplier with lower price)
    D4: The consecutive 3rd column from the supplier selected with the SUPPLIER LEAD TIME (The lead time of the supplier with lower price)
    E4: The consecutive 4rd column from the supplier selected with the SUPPLIER BRAND (The brand of the supplier with lower price

    See atached screenshot for more details
    Minimum Price.png

  2. #2
    Forum Expert daffodil11's Avatar
    Join Date
    07-11-2013
    Location
    Phoenixville, PA
    MS-Off Ver
    MS Office 2016
    Posts
    4,465

    Re: Get minimum value, and If two cells match from a row, return values from the consecuti

    =choose((f4=b4)*1+(j4=b4)*2+(n4=b4)*3,g4,k4,o4)
    =choose((f4=b4)*1+(j4=b4)*2+(n4=b4)*3,h4,l4,p4)
    =choose((f4=b4)*1+(j4=b4)*2+(n4=b4)*3,i4,m4,q4)

    and copy down
    Make Mom proud: Add to my reputation if I helped out!

    Make the Moderators happy: Mark the Thread as Solved if your question was answered!

  3. #3
    Registered User
    Join Date
    07-18-2016
    Location
    Barcelona
    MS-Off Ver
    Mac Office 2010
    Posts
    2

    Re: Get minimum value, and If two cells match from a row, return values from the consecuti

    Thanks so much!

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 5
    Last Post: 03-25-2015, 05:30 PM
  2. [SOLVED] return the number of cells with the most consecutive specific values.
    By Bab1 in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 08-13-2014, 07:11 AM
  3. [SOLVED] Using Index Match with a Criteria to return a minimum
    By david0985 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 03-18-2014, 12:59 PM
  4. Array to average 3 non consecutive minimum value cells out of 4
    By JJGF in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 11-17-2013, 02:02 AM
  5. Replies: 1
    Last Post: 07-03-2013, 12:14 AM
  6. [solved] minimum value of 3 consecutive cells in a column
    By DaanN in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 12-16-2012, 08:48 PM
  7. Replies: 2
    Last Post: 11-12-2012, 06:26 AM

Tags for this Thread

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1