troubleshooting Question

V lookup

Avatar of Chrisjack001
Chrisjack001Flag for United States of America asked on
Microsoft AccessMicrosoft Excel
6 Comments1 Solution293 ViewsLast Modified:
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

InvoiceDetail-Subtable-TEST.xlsx
Invoices-Table-Update-TEST.xlsx
Join the community to see this answer!
Join our exclusive community to see this answer & millions of others.
Unlock 1 Answer and 6 Comments.
Join the Community
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 6 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros