Results 1 to 2 of 2

Formula Help Please

Threaded View

  1. #1
    Registered User
    Join Date
    07-15-2018
    Location
    Milton Keynes, Bucks
    MS-Off Ver
    365
    Posts
    1

    Formula Help Please

    Hi All,
    I am trying to figure out a formula that will return the lowest price from a data set where there are multiple suppliers and products of the same name.

    How can I make a formula to return the lowest price product from that supplier, of which there are several with the same name, both Suppliers and Products.

    Please see attached example sheet
    Attached Files Attached Files
    Last edited by IanB72; 07-15-2018 at 02:17 PM.

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: 12-07-2016, 09:18 AM
  2. Replies: 3
    Last Post: 12-04-2014, 01:27 PM
  3. Using vLookup based on results from a vLookup & returning an undetermined list
    By NormalityBan in forum Excel Formulas & Functions
    Replies: 15
    Last Post: 08-14-2014, 05:02 AM
  4. Replies: 0
    Last Post: 12-26-2013, 01:12 PM
  5. Display Cell within VLookup range that excel thinks matches the VLookup Value
    By headachexcelperson in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 09-04-2013, 04:56 PM
  6. vlookup? match? index? MULTIPLE criteria for vlookup search problem....
    By aborg88 in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 02-11-2013, 09:56 AM
  7. Replies: 5
    Last Post: 07-29-2009, 07:53 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