labrecquev
New Member
- Joined
- Feb 22, 2016
- Messages
- 1
Hi guys, first post here,
I've been working on a problem for a couple of days in PowerPivot.
I want a new column to lookup for a match between some text contained in a string and a lookup table, and to return column 2 of the lookup table.
Acutal table
<tbody>
</tbody>
Lookup table
<tbody>
</tbody>
I've tried using wildcards in the LOOKUPVALUE different ways:
=LOOKUPVALUE(lookuptable[Return], "*lookuptable[Value]*", actualtable[LookupColumn])
I've also tried "*", or only *, without result...
I was able to make it work in excel with INDEX(MATCH), but not in PowerPivot.
I've been working on a problem for a couple of days in PowerPivot.
I want a new column to lookup for a match between some text contained in a string and a lookup table, and to return column 2 of the lookup table.
Acutal table
Lookup column | Calculated column |
Ok w.m white | White Marble |
whitemarble B | White Marble |
<tbody>
</tbody>
Lookup table
Value | Return |
w.m | White Marble |
whitemarble | White Marble |
<tbody>
</tbody>
I've tried using wildcards in the LOOKUPVALUE different ways:
=LOOKUPVALUE(lookuptable[Return], "*lookuptable[Value]*", actualtable[LookupColumn])
I've also tried "*", or only *, without result...
I was able to make it work in excel with INDEX(MATCH), but not in PowerPivot.