Populate other data based on unique value and Repository file

Hey there,

I'm in need of help for a following situation.

I have a huge excel workbook (~50k records) used a repository for all the data (~25 columns) for an item.
Example (similar concept)
2013_04_24_11_08_20_Book1_Compatibility_Mode_Excel_Trial_.gif

Now, I would like to do some verification of each field with the physical item so I have a team to go to the physical item to record the information on a blank workbook but with the column headers. They also ask the personnel for the details like in the example, personnel ID/Name/area group (information which even I myself do not know). This will help verify if the personnel is still the same or if the item has moved to another area/group.

Instead of the approach, I have thought of another method where I will auto-populate the data of that item using the unique value (SN) and approach the personnel to VERIFY the detail instead keying in all the data manually.

Note I do not wish to give the team visibility to the main repository (locked & hide the workbook)

Back to the working blank workbook, I would like to auto-populate the remaining 24 fields based on the SN Column matching back to the main repository.
However, I do not want to create 24 v-lookups for each field as the repository is very huge.

Is there any way around this? Thanks in advance!!

Hi Qwertified

The way that I would approach this is to give the verification team a subset of the repository - that is to say, if the team are to check say 100 serial numbers, copy and paste 100 rows into a workbook. In this way, they cannot have access to the main repository. When they return the checked items, I would use VBA to load their updated data into my repository.

Let me know if I can explain this further, or (more likely) tell me why this will not work for you.

Regards
Alasatair