Forum Discussion
Solved
How search one value in excel and get all results?
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 formul...
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.
SergeiBaklan
Thanks a lot
I could solve the problem by combining multiple formulas together including index. aggregation, etc. It is completely working for me.
Yousef72_Yud , yes, also a variant, just with Power Query that's much easier. Anyway, great to know you solved that.