Home

How search one value in excel and get all results?

%3CLINGO-SUB%20id%3D%22lingo-sub-440685%22%20slang%3D%22en-US%22%3EHow%20search%20one%20value%20in%20excel%20and%20get%20all%20results%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-440685%22%20slang%3D%22en-US%22%3E%3CP%3EHello%3CBR%20%2F%3EI%20am%20working%20on%20my%20thesis.%20I%20need%20to%20search%20one%20value%20in%20excel%20and%20get%20all%20results.%20I%20used%20vlookup%20formula%20but%20it%20only%20gives%20one%20result.%20Can%20you%20please%20instruct%20me%20how%20to%20change%20vlookup%20formula%3F%3CBR%20%2F%3EFor%20example%2C%20in%20the%20table%20below%20I%20want%20to%20search%20NOA1%20from%20between%2010000%20number%20of%20data%20and%20get%20the%20exact%20names%20in%20front%20of%20it%20from%20thousand%20of%20results.%20How%20should%20I%20write%20the%20formula%3F%26nbsp%3B%3C%2FP%3E%3CTABLE%3E%3CTBODY%3E%3CTR%3E%3CTD%3ENOA1%3C%2FTD%3E%3CTD%3Ehsa-miR-640%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3ENOA1%3C%2FTD%3E%3CTD%3Ehsa-miR-378a-5p%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3ENOA1%3C%2FTD%3E%3CTD%3Ehsa-miR-4436b-5p%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3ENOA1%3C%2FTD%3E%3CTD%3Ehsa-miR-6821-3p%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3ENOA1%3C%2FTD%3E%3CTD%3Ehsa-miR-4312%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3ENOA1%3C%2FTD%3E%3CTD%3Ehsa-miR-3653-5p%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3ENOA1%3C%2FTD%3E%3CTD%3Ehsa-miR-6790-3p%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3ENOA1%3C%2FTD%3E%3CTD%3Ehsa-miR-3934-5p%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3ENOA1%3C%2FTD%3E%3CTD%3Ehsa-miR-764%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3ENOA1%3C%2FTD%3E%3CTD%3Ehsa-miR-125a-3p%3C%2FTD%3E%3C%2FTR%3E%3C%2FTBODY%3E%3C%2FTABLE%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-440685%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ECharting%3C%2FLINGO-LABEL%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-443259%22%20slang%3D%22en-US%22%3ERe%3A%20How%20search%20one%20value%20in%20excel%20and%20get%20all%20results%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-443259%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F319661%22%20target%3D%22_blank%22%3E%40Yousef72_Yud%3C%2FA%3E%26nbsp%3B%2C%20duplication%20of%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2FExcel%2FHow-search-one-value-in-excel-and-get-all-results%2Fm-p%2F440694%23M28828%22%20target%3D%22_blank%22%3Ehttps%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2FExcel%2FHow-search-one-value-in-excel-and-get-all-results%2Fm-p%2F440694%23M28828%3C%2FA%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
Yousef72_Yud
Occasional Contributor

Hello
I am working on my thesis. I need to search one value in excel and get all results. I used vlookup formula but it only gives one result. Can you please instruct me how to change vlookup formula?
For example, in the table below I want to search NOA1 from between 10000 number of data and get the exact names in front of it from thousand of results. How should I write the formula? 

NOA1hsa-miR-640
NOA1hsa-miR-378a-5p
NOA1hsa-miR-4436b-5p
NOA1hsa-miR-6821-3p
NOA1hsa-miR-4312
NOA1hsa-miR-3653-5p
NOA1hsa-miR-6790-3p
NOA1hsa-miR-3934-5p
NOA1hsa-miR-764
NOA1hsa-miR-125a-3p
1 Reply