Look for values from a different sheet and return it

[Closed]
Report
Posts
2
Registration date
Tuesday December 4, 2012
Status
Member
Last seen
December 4, 2012
-
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
-
Hello,

So I am working with a file that has 2 sheets. Sheet 1 has columns A,B,C,D

Sheet 2 has Column. A B C D

For both sheets, column A= Account number, B= Name, C= spread. D= Class

Now Sheet 1 has 500 accounts, with old data in column C. Sheet 2 has 100 accounts with updated data in column C. Data in either account is not in any order (ascending or descending. Can not be an order, as we use a suffix on every account)

Sheet one's 500 accounts include the 100 accounts from sheet 2.

Now I want to put a formula in column C of sheet 1 that will look for the updated values in Sheet 2/Column C and return it on Sheet 1/Column C.

So even though I will drag down the formula in column C, across 500 accounts in Sheet 1, it will only update the value for the accounts that exists in sheet 2. The remaining values will remain as is. I.E. I dont want the remaining accounts to show Zero or N/A.

Please help!!

Thanks in advance.

2 replies

Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
768
What formula are you using. It seems Vlookup should work

=VLOOKUP(A2,Sheet2!A:D,3, FALSE)
Posts
2
Registration date
Tuesday December 4, 2012
Status
Member
Last seen
December 4, 2012

Thanks rizvisa1. I tired that. but the problem is that I get N/A for accounts that does not exist in Sheet 2. I need those particular Spreads to keep their previous values and not "update" to N/A.
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
768
any formula cannot retain previous value in the cell as cell contains value. For your NA issue
you can try

=IF(ISERROR(VLOOKUP(A2,Sheet2!A:D,3, FALSE)), "", VLOOKUP(A2,Sheet2!A:D,3, FALSE))