Match to min value rows and columns

[ldarley]

Hi,

I'm stuck with a formula, I have my data in a grid as follows:

Reference	Place 1	Place 2	Place 3
Postcode 1	1.112	0.013	0.123
Postcode 2	2.321	1.132	1.532
Postcode 3	1.393	1.932	2.392

I need to match to the minimum value based on the postcode criteria. So in another worksheet I have my data in a column with all the postcodes in it, lets call it column A and in column B I then want to have the formula that will match the corresponding row value from column A to the minimum distance value associated with that value. I've index(matched) - the easy bit, to the correct row associated with the postcode but then once I'm there how to I find column that points to the minimum value?

Any help is as always appreciated!

 

[earthworm]

Try this

Book1
	A	B	C	D	E	F	G	H	I
1	Reference	Place 1	Place 2	Place 3	Min Value	Place
2	Postcode 1	1.112	0.013	0.123	0.013	Place 2		Postcode 1	Place 2
3	Postcode 2	2.321	1.132	1.532	1.132	Place 2		Postcode 2	Place 2
4	Postcode 3	1.393	1.932	2.392	1.393	Place 1		Postcode 3	Place 1
Sheet1

Cell Formulas
Range	Formula
E2:E4	E2	=MIN(B2:D2)
F2:F4	F2	=INDEX($B$1:$D$1,MATCH(E2,$B2:$D2,0))
I2:I4	I2	=VLOOKUP(H2,A:F,6,0)

 

[ldarley]

Brilliant thanks Earthworm I was trying to think how to do it all in one formula and should have just thought to break it up like that, that's perfect thank you!!