Solved: Obtain value based on two other columns - Page 2

WiredCats · 04-08-2019 12:43 PM

This may be easy, but I am struggling with it. I want to lookup a value based on two other column values. Example:

Column 1 Coumn 2 Column 3
23 Red ABC
45 Blue XYZ

So, I want to use Column 1 = “23”, Column 2 = “Red”, and get a return value of “ABC”

Thanks
Matt

Steve

Within a SELECT() row-match expression, you don’t need to specify the table name if referring to the table the SELECT() is being used on:

ANY(SELECT(OtherTable[Column3],AND([Column1]=[_THISROW].[Column5],[Column2]=[_THISROW].[Column6])))