Forum Discussion
Multi Level Index Match IF - open to suggestions
Morning all, need some assistance. Have a very complex lookup matching process i need to improve, index match has some limitations, and vlookup (in a previously much more simplified version of the d...
Hi Joe,
You may use simulation of INDEX/MATCH on 2D array. For data like here
the formula could be
= IF(SUMPRODUCT(--($B$4:$H$12=K1))=0, "No match",INDEX($U$4:$U$12,SUMPRODUCT(($B$4:$H$12=K1)*ROW($B$4:$H$12))-ROW($B$4:$H$12)+1))
However, it works if the lookuped data occurs in your array not more than once.