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!!