Forum Discussion
Tough formula for index/match/vlookup/small and array.....I can't solve!
I am usually pretty good with formulas but can't figure this one out! I have a bunch of data in the chart on the left that needs to be reorganized into the format in the middle. The ultimate output s...
Hi gms4b
Your requirement is quite achievable, since you look for two different values for each category therefore you need to use two different formulas (one for minimum value & other for maximum value). You can try below formulas,
=MIN(IF($A$3:$A$12=F$2,IF($B$3:$B$12=$E3,$C$3:$C$12)))
=MAX(($A$3:$A$12=F$2)*($B$3:$B$12=$E4)*$C$3:$C$12)
Please use (Ctrl + Shift + Enter) as they are array formula.
I have also attached a sample file for your reference. Please let me know if it works for you.
Thanks
Tauqeer