Parsing/Grouping Column Values Into Variables For Rule-Based Row Filter Question

I’ve tried searching for this solution on the forums and I’m probably blind or just really missing something, but I need help with solutioning a method for comparing values.

I have an Excel spreadsheet that contains 2 sheets (MF1, Validation Data). The MF and sheet contains rows of data relating to employee records. The “Validation Data” tab contains a table with what are considered valid values for most of the columns in the MF sheet. The columns it has are:

TabName - (referencing which Excel sheet the valid codes are for, in this case “MF”)

FieldCheck - (the column name the valid codes are for)

ValueCheck - (a valid code that for that column)

Info - (contains additional values that can be used for validation)

Info2 - (contains other additional values use for comparing/validating codes)

An example might be two rows for each valid Gender code for the Gender column on the MF1 tab. For example:

MF1, Gender, M

MF1, Gender, F

Some columns can have hundreds of valid codes/values that would need to be used for comparison in the Rule-Based Row Filter.

In an ideal world, I would like to be able to write a Rule-Based Row Filter expression that would allow me to output rows from the MF1 tab that don’t match the valid codes on the Validation Data tab. In addition to this, I would need the Variable to have the name of the column it is being used to validate codes on, so expression writing is straightforward.

I’m really sorry if I’m missing something super obvious (and I feel like I must be), but I’m just not getting why I can’t figure this out.

Any help you could offer would be greatly appreciated.