Apr 11 2019 01:37 PM
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?
NOA1 | hsa-miR-640 |
NOA1 | hsa-miR-378a-5p |
NOA1 | hsa-miR-4436b-5p |
NOA1 | hsa-miR-6821-3p |
NOA1 | hsa-miR-4312 |
NOA1 | hsa-miR-3653-5p |
NOA1 | hsa-miR-6790-3p |
NOA1 | hsa-miR-3934-5p |
NOA1 | hsa-miR-764 |
NOA1 | hsa-miR-125a-3p |