Neither MS Access nor SQL maintain a Vlookup function
<p>I have a table with an ID like below:-
Unit| Function | OrgID
000| 000 | 21</p>

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

<p>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.</p>

<p>Any one have any suggestions?</p>

<p>Thanks,</p>

<p>Vin</p>