Multiple Variable Lookup with wildcard.|Power Query|Excel Forum|My Online Training Hub

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)