MS ACCESS Vlookup anywhere in Field

I have a table with an ID like below:- Unit| Function | OrgID 000| 000 | 21

I have another table:- Unit | Function | Subfunction | Level 4 | Level 5 01| 54| 65 | 21 | 96

I want to update the first table with the values (Unit, Function) from the second table. However the OrgID can in any field within unit, function, subfunction, level 4, level 5. So i cannot do a join on a specific column and use an update and it won't always be the same column.

Any one have any suggestions?

Thanks,

Vin