Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,986 questions
Multiple Condition Match Look-up [INDEX, MATCH, LEFT, SEARCH]
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(284.8, 53%, 37%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMY%3C/text%3E%3C/svg%3E)
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
{count} votes
-
Emi Zhang-MSFT 25,711 Reputation points Microsoft Vendor2024-11-07T07:43:17.8133333+00:00 Hi，
Please be a bit more precise to explain your requirement or you can upload a screenshot so that I can get more accurate solutions to this problem. I’m glad to help and follow up your reply.
-
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(307.2, 41%, 39%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EPE%3C/text%3E%3C/svg%3E)
Paul Edstein 571 Reputation points2024-11-07T08:51:24.5066667+00:00 This question doesn't seem to have anything to do with MS Word.
Sign in to comment
Sign in to answer