Hi, I need a multiple variable lookup with wildcard.
Master Look Up
cta scta sscta value cta scta sscta value should
1 * * X 1 3 4 X
2 1 * Y 1 3 1 X
* 2 * Z 2 1 1 Y
* 3 3 X 2 1 3 Y
3 2 1 Z
I Attached an image of the same table i copied above. I need for the * sign to work as a wildcard. Im trying to merge both tables. The column "value should" is what Im looking to be the end result. Note: The Look Up has no double posibilities (eg: cta 1 with value X and scta 2 with value Z in the master data so the "value should" for the look up table cta 1 and scta 2 could be either X or Z)
There is no screenshot. Please try again and don't forget to press "Start upload" before you submit your reply. And, perhaps wise to also upload the file itself. That would make it easier to help.
