I need some help on my excel for updating a data sheet for updated values.
I have Sheet1 "Names" and "Remarks" columns which are old data and use as a database and Sheet2 has updated details of "Remarks" column for few "Names". Eg. Sheet 1 has over 100 names and remarks and Sheet2 has updated remarks of 27 Names listed on Sheet1.
I need a formula to update the Sheet1 "Remarks" column if names from Sheet2 are matching.
I have tried the formula below, which works but it gives #N/A on Sheet1 for those names which are not available on Sheet2. I want to update only those updated remarks for the matching names on sheet2.
=INDEX(Sheet2!E$2:F$27,MATCH(Sheet1!A2,Sheet2!E$2:E$27,0),2)
Sheet1 Column A - Names, Column B - Remarks ~ Old records over 100 entries Sheet2 COlumn E - Names, Column F - Remarks ~ New records 26 entries
2.If Sheet2 has new name and records, I want them also to be added to the Sheet1.
Thank you!
Bookmarks