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

FHS-Tech
FHS-Tech used Ask the Experts™
on
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!
Comment
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...
=IFERROR(VLOOKUP(B1,[Old.xlsx]Sheet1!$B$1:$C$6,2,0),"")

Regards,
Brian.Old.xlsxNew.xlsm

Author

Commented:
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