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?