LOOKUP ROW, THEN COLUMN and find Min Value

[bstboy]

FEB FEB FEB FEB MAR MAR MAR MAR APR APR APR APR
A 0.90 0.32 0.69 0.78 0.50 0.83 0.62 0.36 0.78 0.59 0.25 0.65
B 0.71 0.20 0.97 0.09 0.19 0.58 0.44 0.11 0.47 0.79 0.92 0.20
C 0.13 0.89 0.09 0.96 0.56 0.46 0.38 0.17 0.34 0.73 0.13 0.59
D 0.10 0.90 0.67 0.04 0.48 0.60 0.66 0.86 0.53 0.64 0.92 0.08

Sorry, I can't get the minsheet add in to work but what I want to do first, is look up an item number (A, B, C, D), then look up a corresponding month and find the min value within that range of 4 values.

So for instance, I want to find the min value of item A in February, then it would return .32.

Thanks

 

[awoohaw]

Try this: (you may need to enter with the Cntr-Shft-Entr Keystroke:

Depending on your verison of excel, there may be other formula functions that can work. Please update your profile so your version shows up on your posting button.

Book1
	A	B	C	D	E	F	G	H	I	J	K	L	M
1		FEB	FEB	FEB	FEB	MAR	MAR	MAR	MAR	APR	APR	APR	APR
2	A	0.9	0.32	0.69	0.78	0.5	0.83	0.62	0.36	0.78	0.59	0.25	0.65
3	B	0.71	0.2	0.97	0.09	0.19	0.58	0.44	0.11	0.47	0.79	0.92	0.2
4	C	0.13	0.89	0.09	0.96	0.56	0.46	0.38	0.17	0.34	0.73	0.13	0.59
5	D	0.1	0.9	0.67	0.04	0.48	0.6	0.66	0.86	0.53	0.64	0.92	0.08
6
7		FEB	MAR	APR
8	A	0.32	0.36	0.25
9	B	0.09	0.11	0.2
10	C	0.09	0.17	0.13
11	D	0.04	0.48	0.08
Sheet1

Cell Formulas
Range	Formula
B8:D11	B8	=1/MAX(IFERROR((1/(($B$2:$M$5)*($A8=$A$2:$A$5)*(B$7=$B$1:$M$1))),0))

​

​

​