Forum Discussion
How search one value in excel and get all results?
Yousef72_Yud , there are these 500 values kept? If you have your main list with dozen thousand of records and another one with 500 values, based on which you'd like to extract data from the first list, with Power Query you may query both lists, merge them for values only from the second list and land result back to Excel sheet.
Why don't you use 'Filter' option for searching a value?
May be 'find all' function help you.
Logaraj Sekar
I tried the filter and find function. The problem is i want to search almost 500 number of values between thousands of cells and in result take bake the exact results which is written in front of it. I found vlookup as the best function. But i think it needs improvements, can you please help me to write the best formula?