Share via

Multiple Condition Match Look-up [INDEX, MATCH, LEFT, SEARCH]

Md Yeasin 0 Reputation points
2024-11-07T05:51:39.1166667+00:00

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

Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
2,048 questions
Word Management
Word Management
Word: A family of Microsoft word processing software products for creating web, email, and print documents.Management: The act or process of organizing, handling, directing or controlling something.
941 questions
Excel Management
Excel Management
Excel: A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.Management: The act or process of organizing, handling, directing or controlling something.
1,740 questions
Microsoft Configuration Manager

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.