I've been wandering on this forum for a bit now but cannot find the answer. I'm a bit of a newby when it comes to power bi/power pivot so I hope you can help me out (I'm using power pivot bytheway).

What I would like to have is the following: I have a look up table with 4 variables (in reality it much more rows) and I want to have a calculated column which gives me the "Name" when all 4 variables are met. I used the DAX function LOOKUPVALUE and it works fine when all the variables are numbers. However here is the catch. If a "costcntr" is blank in the lookupvalue any value will do. So in the case of john it can be 2164, 2264, 2364 etc. the same applies for Eva. I was thinking about an OR/IF function but I'm not sure if this could do the trick and how to implement this into the LOOKUPVALUE. Any sugestions on how I can solve this puzzle would be much appreciated? Thank you in advance.

Lookup table

Name_____Costcntr1|Costcntr2|Costcntr3|Costcntr4

Walter________2_______ 4_______6_______5______

Erik__________1_______ 5_______7_______6______

John _________2_______________ 6_______4______

Lisa__________2________4______ 6_______6______

Eva__________2________1_______8______________

Costcntr1|Costcntr2|Costcntr3|Costcntr4|Wanted Outcome

___2________4________6________6________Lisa

___2________3________6________4________John

___2________1________8________9________Eva

___2________1________8________2________Eva