+ Reply to Thread
Results 1 to 2 of 2

Return Title to matched column

  1. #1

    Return Title to matched column

    I have a spreedsheet of data. Bsically it contains various products and
    various suppliers. The products are listed down the left side and the
    suppliers along the top row. There is obviously more than one price per
    product ie from each individual supplier. I have set up a basic min function
    to return the cheapest price and a VERY complicated IF set of formulas to
    return the suppliers names at present. However my biggest problem at
    theminute is that i have more than 7 suppliesr and wish to simply get the
    minimum number in the row to be represented by the cheapest suppliers name in
    a set column. Hope you can help . . . I think it may be the HLookup that i
    need ot use but i am having trouble

  2. #2
    Max
    Guest

    Re: Return Title to matched column

    Assuming data is in cols A to K, data from row2 down, with products listed
    in col A and suppliers' quotes in cols B to K (10 suppliers, say)

    Put in L2, copy down:
    =INDEX($B$1:$K$1,MATCH(MIN(B2:K2),B2:K2,0))

    Note that in the event of any ties in the lowest prices,
    only the leftmost lowest price supplier will be extracted

    Sample illustration at:
    http://cjoint.com/?cvhf6Mrxy5
    Extract Lowest Price Supplier per Prod_matt_newusers.xls
    --
    Max
    Singapore
    http://savefile.com/projects/236895
    xdemechanik
    ---
    "[email protected]" <[email protected]@discussions.microsoft.com> wrote in
    message news:[email protected]...
    > I have a spreedsheet of data. Bsically it contains various products and
    > various suppliers. The products are listed down the left side and the
    > suppliers along the top row. There is obviously more than one price per
    > product ie from each individual supplier. I have set up a basic min

    function
    > to return the cheapest price and a VERY complicated IF set of formulas to
    > return the suppliers names at present. However my biggest problem at
    > theminute is that i have more than 7 suppliesr and wish to simply get the
    > minimum number in the row to be represented by the cheapest suppliers name

    in
    > a set column. Hope you can help . . . I think it may be the HLookup that i
    > need ot use but i am having trouble




+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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