In Excel - Retrieving Multiple text data search

%3CLINGO-SUB%20id%3D%22lingo-sub-3199620%22%20slang%3D%22en-US%22%3EIn%20Excel%20-%20Retrieving%20Multiple%20text%20data%20search%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3199620%22%20slang%3D%22en-US%22%3E%3CP%3EMy%20team%20has%20built%20an%20acronym%20data%20dictionary%20and%20there%20are%20a%20few%20duplicate%20acronyms%20in%20a%20column%20with%20different%20translations%20and%20descriptions.%20I%20have%20created%20the%20following%20search%20form%20that%20returns%20a%20value%20but%20I%20would%20like%20to%20make%20sure%20that%20when%20there%20are%20multiple%20values%20(or%20acronyms)%20all%20are%20shown%20for%20the%20person%20conducting%20the%20search%20to%20see%20what%20makes%20the%20most%20sense%20for%20their%20data%20dictionary%20search.%3C%2FP%3E%3CP%3ESample%20of%20form%3A%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22LL3241_0-1645546444298.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F350387i59A9A59479130121%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22LL3241_0-1645546444298.png%22%20alt%3D%22LL3241_0-1645546444298.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3EIn%20the%20acronym%20or%20term%20column%20within%20the%20table%20we%20have%20two%20IP%20related%20acronyms.%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22LL3241_1-1645546519928.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F350388i5A7FA21419EABB12%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22LL3241_1-1645546519928.png%22%20alt%3D%22LL3241_1-1645546519928.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ECan%20anyone%20give%20me%20some%20guidance%20on%20how%20to%20extract%2F%20retrieve%20both%20acronyms%20and%20show%20the%203%20different%20cells%20showing%20Acronym%20or%20term%3B%20Translation%3B%20Description%20in%20my%20search%20table%20above%20and%20not%20just%20one%3F%20Thank%20you.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-3199620%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3199930%22%20slang%3D%22en-US%22%3ERe%3A%20In%20Excel%20-%20Retrieving%20Multiple%20text%20data%20search%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3199930%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1314745%22%20target%3D%22_blank%22%3E%40LL3241%3C%2FA%3E%26nbsp%3BIf%20you%20are%20using%20MS365%20or%20Excel%202021%2C%20look%20into%20the%20FILTER%20function.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

My team has built an acronym data dictionary and there are a few duplicate acronyms in a column with different translations and descriptions. I have created the following search form that returns a value but I would like to make sure that when there are multiple values (or acronyms) all are shown for the person conducting the search to see what makes the most sense for their data dictionary search.

Sample of form:

LL3241_0-1645546444298.png

In the acronym or term column within the table we have two IP related acronyms.

LL3241_1-1645546519928.png

 

Can anyone give me some guidance on how to extract/ retrieve both acronyms and show the 3 different cells showing Acronym or term; Translation; Description in my search table above and not just one? Thank you.

1 Reply

@LL3241 If you are using MS365 or Excel 2021, look into the FILTER function.