I have two tables that are being pulled from access into 2 separate worksheets. What I would like to do is map the fields. Each table has a varying number of fields that are like a field in the others table. The do not change so if STATUS_CLOSED is in table 1 it will have a field LIKE it in the other table called RESOLVED. Sometimes one field will exist and it will not have a "partner" in the other table, but I only care about mapping the fields that can match up.

How do you do this in excel?