Multiple Condition Match Look-up [INDEX, MATCH, LEFT, SEARCH]
Md Yeasin
0
Reputation points
If after hyphen( -) full match found with A vs B + if left 3 of D match found with A= result need "found" Excel version 2021If after hyphen( -) full match found with A vs B + if left 3 of D match found with A= result need "found" Excel version 2021AResultSourceEPR1120-N9700FoundET01160 - N1109ES01150-N5775ES01150 - N1109ES01150-N1109ES01150 - N5775ET01160-N1109RS01110 - N0839RS01110-N0839EPR1075 - N9700
Sign in to answer