Forum Discussion
Solved
Compare 2 Columns, Return 3 values
Hi, I want to compare two columns on the same table. If the Columns match it should return 3. If thet dont match return 2. If both are blank return 1. I want to use these values in conditi...
SnymanGrobler
TryMatch = SWITCH ( TRUE (), Table[Column1] = BLANK ( ) && Table[Column2] = BLANK ( ), 1, Table[Column1] = Table[Column2], 3, 2 )or
Match = SWITCH ( TRUE (), Table[Column1] & Table[Column2] = "", 1, Table[Column1] = Table[Column2], 3, 2 )
SnymanGrobler
Try
Match =
SWITCH (
TRUE (),
Table[Column1] = BLANK ( ) && Table[Column2] = BLANK ( ), 1,
Table[Column1] = Table[Column2], 3,
2
)or
Match =
SWITCH (
TRUE (),
Table[Column1] & Table[Column2] = "", 1,
Table[Column1] = Table[Column2], 3,
2
)
Thank you very much, second solution worked.