Forum Discussion
INDEX MATCH plus MINIFS
Hi, I have a table with data. That contains temperatures and dates, but it's not every day. For example: DATA 1 A B C D 2 Date Station A Temp Station B Temp Station C Temp 3 N...
=MIN(INDEX($C$4:$E$9,MATCH(H4,$B$4:$B$9,0),))=INDEX($C$3:$E$3,MATCH(MIN(INDEX($C$4:$E$9,MATCH(H4,$B$4:$B$9,0),)),INDEX($C$4:$E$9,MATCH(H4,$B$4:$B$9,0),),0))An alternative could be these formulas for Min Temp and Station. If you want to get rid of the #NA results you can wrap the formula in IFERROR.
=IFERROR(MIN(INDEX($C$4:$E$9,MATCH(H4,$B$4:$B$9,0),)),"")=IFERROR(INDEX($C$3:$E$3,MATCH(MIN(INDEX($C$4:$E$9,MATCH(H4,$B$4:$B$9,0),)),INDEX($C$4:$E$9,MATCH(H4,$B$4:$B$9,0),),0)),"")
=MIN(INDEX($C$4:$E$9,MATCH(H4,$B$4:$B$9,0),))=INDEX($C$3:$E$3,MATCH(MIN(INDEX($C$4:$E$9,MATCH(H4,$B$4:$B$9,0),)),INDEX($C$4:$E$9,MATCH(H4,$B$4:$B$9,0),),0))An alternative could be these formulas for Min Temp and Station. If you want to get rid of the #NA results you can wrap the formula in IFERROR.
=IFERROR(MIN(INDEX($C$4:$E$9,MATCH(H4,$B$4:$B$9,0),)),"")=IFERROR(INDEX($C$3:$E$3,MATCH(MIN(INDEX($C$4:$E$9,MATCH(H4,$B$4:$B$9,0),)),INDEX($C$4:$E$9,MATCH(H4,$B$4:$B$9,0),),0)),"")
Occam's razor - simplest solution is the best. Not sure how I convinced myself I needed MINIFS when MIN works just fine. Thanks!
