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