This may be a little hackier than what you had in mind, but you can achieve this by importing your Personnel Name and ID data to a new sheet and then using Excel's lookup functions on this imported data to get the IDs for the personnel in the computer list.
Step 1: Import your Access Personnel ID data to Excel.
Just use Excel's Get External Data feature to get the data from Access. You can put the imported data on a new sheet. You'll probably choose to delete the sheet when you're done anyway.
![enter image description here](../../I/static/images/0b8a43f81b31e57db952b33fbf3f02cb4eba1509c09769cd2176c18e9ab4592d.png)
Step 2: Use INDEX and MATCH to look up the Personnel IDs for the names in your computer list.
In a separate column on the sheet with your computer data, you can use a formula like the following to look up the ID for the Employee named in A3
.
=INDEX(Table_Database10.accdb[[#All],[EmployeeID]],MATCH(Formulas!A3,Table_Database10.accdb[[#All],[Last Name]],0))
You can get the database references by selecting the appropriate columns from your imported data. Excel will generate the database field references.
![enter image description here](../../I/static/images/0f64fd883cee8b4fcc0a235ccfd239bcdbc434c9ce17da8252729514d2103500.png)
Step 3: Copy values from these formulas over your Personnel names in your computer data.
After doing this you can remove the data and formulas you added in the previous steps.