I have an excel file with the following fields...

Last Name, First Name, Service Line, 2010 Revenue, 2011 Revenue (spreadsheet contains over 6000 rows of data, and many of the names show up more than once under different service lines).

At the end of 2012 I want to be able to add 2012 Revenue to the existing excel file, however my NEW list will likely have changes in the number of physicians practicing in each service line due to changes in staffing throughout the year. The new file will be set up the same...

Last Name, First Name, Service Line, 2012 Revenue.

Is there a way to have excel look at the "last name" and "first name" in an excel file and if there is a match insert the "2012 Revenue"? For those cases where there is no match because the physician is NEW how can I automate the formula so that it adds their info to the existing file? For those cases where there is no match because the physician has left the area, how can I automate the formula so that it adds "zeros" to the "2012 Revenue"?

I think I've figured out the first part using the INDEX and MATCH formulas but am stuck on the last part. Would Access make this any easier? I do not know anything about accesss. I've been poking around with it all afternoon and havn't found a solution. Thanks!