Excel: copy contents of one cell from one file into a cell of another file

FHS-Tech used Ask the Experts™
I have two spreadsheets: New and Old.  Both have a column B labeled "Record ID".  I would like to be able check if B2 "Record ID" in Spreadsheet New exists in column B of Spreadsheet Old and if it does, copy the contents from C2 of Old Spreadsheet into C2 of New spreadsheet.

Excel 2010
Windows 7

Any takers?

Muchas Gracias!
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Hi, FHS-Tech.

Please see attached. The formula in New.xlsl is...



That worked amazingly well!  Thanks for the help.
Thanks, FHS-Tech, glad to help.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial