I use Excel 2007. I have a spreadsheet called “InvoiceDetail Subtable_TEST” with about 28,000. Column C field is called “StudyID” and is currently blank. I have another spreadsheet called “Invoice Table Update_Test” which has a column E field called “Study”. This spreadsheet has another field column A called “InvoiceID” which is a unique field with no duplicates. This same field exists in the “InvoiceDetail Subtable_TEST” spreadsheet in column B also called “InvoiceID”. In this spreadsheet, they are duplicated depending on their “StudyID” which is currently blank.
For example for “InvoiceID” 10550 the “StudyID” that should go in the blank space in the “InvoiceDetail Subtable_TEST” spreadsheet should be “SR05” based on the corresponding “Study” in the “Invoice Table Update_Test” spreadsheet. How can I accomplish this goal for about 28000 records in the “InvoiceDetail Subtable_TEST” spreadsheet matching them with the “Invoice Table Update_Test” spreadsheet using a V lookup or a formula. Attached are the 2 spreadsheets. Thanks in advance