Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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 --- " wrote in message ... 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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Need to Improve Code Copying/Pasting Between Workbooks | Excel Discussion (Misc queries) | |||
Lookup values in one column to return another | Excel Worksheet Functions | |||
IF/AND/OR/DATEIF Issue...sorry...long post... | Excel Worksheet Functions | |||
match and count words | Excel Worksheet Functions | |||
Search one column and return value from next column | Excel Discussion (Misc queries) |