Forum Discussion
formula to help select the right data set
help with formula to select the correct data set. below B2 to B5 are input tabs and calculation results in B6 using four different data sets (region 1 to 4). I am able to locate the right match ...
A variant using the reference arrangement of INDEX.
=INDEX((Region_1,Region_2,Region_3,Region_4),RIGHT(B3)*1,MATCH(B5,$B$10:$F$10,0),RIGHT(B4)*1)