INDEX/MATCH function is one of the versatile Combo-functions in #Excel
Here is how to use it to look horizontally instead of the HLOOKUP function.
=INDEX($E$2:$G$2,,
MATCH(MIN(E3:G3),E3:G3,0))
....
Follow for more tips & tricks.
....
#DataAnalytics #cheatsheet #programming
‘HEARTSTOPPER’ wins Outstanding Kids & Family Programming or Film – Live Action at the #GLAADAwards .