Closed Thread
Results 1 to 2 of 2

Lowest Cost Vendor

  1. #1
    Registered User
    Join Date
    United States
    MS-Off Ver
    Excel 2010

    Lowest Cost Vendor

    Perhaps this is the wrong thread to post my question in, but I have been browsing for some time and decided on this one.

    Sheet is set up like this:
    Product 1
    Product 17

    ROW 1 - Vendor Name
    ROW 2-17 - Price

    Initially I had conditional formatting set up to highlight cells with MIN value PER ROW. Now I learned I can set up a formula that will take my selection of cells to discern CHEAPEST TOTAL PRICE (but needs to be by a single vendor), and even that I can have the vendor name pop-up by using the INDEX function.

    SO, I want to know how to build an "open" formula (or macro) that will allow me to select which PRODUCTS I want to order in that shipment, and then which VENDOR to order it from based solely on CHEAPEST TOTAL (Vendor A offers p1 for $14, p3 for $2 and p14 for $10 - though these may not be cheapest PER ITEM, they combine to beat total price for all three items together).

    Is there a way where I can have Excel prompt me to select which products I want to order and then calculate my MIN PRICE? If not, I will just adjust the formula everytime for the individual products, but I need to see the vendor name and total order value in my completed cell, but again, I really need the sheet to compute which total order value is least expensive [ in my mind it looks like this (excuse the formatting, not very good at this) =MIN(A1:D1+A3:D3+A14:D14 [ only if all three products come from same vendor]) and as you have just seen, I don't have the slightest idea with how to begin writing this formula.

    Thank you, if I was not clear, please ask for clarification.

  2. #2
    Forum Moderator jeffreybrown's Avatar
    Join Date
    Cibolo, TX
    MS-Off Ver
    Excel 2016

    Re: Lowest Cost Vendor

    Welcome to the Forum, unfortunately:

    This is a duplicate post and as such does not comply with Rule 5 of our forum rules. This thread will now be closed, you may continue in your other thread.

    Thread Closed.
    Regards, Jeff

Closed Thread

Thread Information

Users Browsing this Thread

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


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