I need a formula to validate data based on the sample below. But fields can contain multiple values when searching for through original and new and then needs to use a look up table as well.
Best I can explain using the sample below is trying to return True or False on:
If Area Old contains "Misc" and Area New contains the correct value based on the table, return TRUE/FALSE
Best I can explain using the sample below is trying to return True or False on:
If Area Old contains "Misc" and Area New contains the correct value based on the table, return TRUE/FALSE