Special "Index/Match" With Power Query

Bilo
Posts: 5
Joined: Fri Nov 16, 2018 7:37 am

Special "Index/Match" With Power Query

Postby Bilo » Mon Feb 11, 2019 7:04 am

Hy Every one,

I would please have your help to deal with the problem in the attached file.
You will find more explanations in the jpeg file,
Thanks in advance

Sincerely
Attachments
VLookUp.jpg
VLookUp.jpg (581.01 KiB) Viewed 187 times
VLookUp.xlsx
(20.36 KiB) Downloaded 3 times

PhilC
Posts: 175
Joined: Tue Sep 09, 2014 8:13 am

Re: Special "Index/Match" With Power Query

Postby PhilC » Tue Feb 12, 2019 12:07 pm

See the Commentary query in the attached workbook.

Solution obtained from: http://www.girlswithpowertools.com/2018/06/search-text-using-list-of-keywords/

Cheers
Phil
Attachments
PPF VLookUp.xlsx
(21.52 KiB) Downloaded 8 times

Bilo
Posts: 5
Joined: Fri Nov 16, 2018 7:37 am

Re: Special "Index/Match" With Power Query

Postby Bilo » Tue Feb 12, 2019 4:41 pm

Hi PhilC, Hi Forum,

Thank you very much for this solution which works very well
I'll look at all this in detail and come back if necessary.
Have a great day

kind regards

Bilo
Posts: 5
Joined: Fri Nov 16, 2018 7:37 am

Re: Special "Index/Match" With Power Query

Postby Bilo » Wed Feb 13, 2019 7:03 am

Hi PhilC,
I just tested on my file of more than 190 000 rows and it works perfectly
Thank you again
Sincerely


Return to “Power Query”

Who is online

Users browsing this forum: No registered users and 3 guests