I'm trying to do an index/match when it returns all the values and sums, if a partial match. The formula I have works perfect with a full match, but what's the best way to do a partial. I tried with *'s, but it doesn't work correct. See attached example workbook. Let me know if any questions. Thanks in advance for the help!
In B2, enter:
and copy across to B2:F2.Formula:
Please Login or Register to view this content.
You may need to be careful with the wildcards you enter.
For example, if you are looking up "ZE036C*1", it will match all values which begin with "ZE036C" and END with "1".
Looking at your "should be" values, then you may want this item to be: "ZE036C*1*", which will match all values which begin with "ZE036C" and then have a "1" somewhere after that.
let Source = #table({"Question","Thread", "User"},{{"Answered","Mark Solved", "Add Reputation"}}) in Source
If I give you Power Query (Get & Transform Data) code, and you don't know what to do with it, then CLICK HERE
Walking the tightrope between genius and eejit...
Awesome, works perfect. Thanks!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks