I am attempting to use DataTable to pull compliance information into a sheet.
The target sheet has columns for Code, Division, and Compliance Status. I need to match on both the Code and Division columns to populate the Compliance Status. However, I need to use the Lookup Mode function to connect the DataTable and cannot use 2 identifiers.
Is there a way around this or a way I am not thinking of to match the data? I don't think I can use the Add & Update Mode because I have ~300 Codes and 30 Divisions and the combinations are random.
I have it just using the Lookup Mode now, but the data wont necessarily be correct if I can't filter on 2 criteria.
Target sheet:
DataTable: