I have excel 2 sheets here borrower id is same, I want to replace C column datas, in 1st sheet is original datas so what data is available in C column that datas need to replace in sheet 2 C column. Suppose borrower id is not match then the borrower id is new in sheet 2 means then in sheet 2 the data should not replace it should remain the same as old already it having.
How will i do this using lookup ?
Bookmarks