Forum Discussion
Solved
Partially Merging Rows From Two Excel files Into One
Hello, I have two excel files on my Mac. Both contain information regarding real estate properties. One file is new and the other is from 2018. The problem I have is that the older file contai...
In K2 on "New Data" you may enter:
=IFERROR(IF(LEN(VLOOKUP($A2,'Old Data'!$A:$W,COLUMN(),0))<>0,VLOOKUP($A2,'Old Data'!$A:$W,COLUMN(),0),""),"")...... and drag it down and across column K:R.
The basic operation is done by this part of the formula:
=VLOOKUP($A2,'Old Data'!$A:$W,COLUMN(),0)Everything else sees to it that you get no NA#! errors (when the property DOES NOT exist in Old Data) or "0" (when the property DOES exist in Old Data but with blank cells in Col K:R).
In K2 on "New Data" you may enter:
=IFERROR(IF(LEN(VLOOKUP($A2,'Old Data'!$A:$W,COLUMN(),0))<>0,VLOOKUP($A2,'Old Data'!$A:$W,COLUMN(),0),""),"")...... and drag it down and across column K:R.
The basic operation is done by this part of the formula:
=VLOOKUP($A2,'Old Data'!$A:$W,COLUMN(),0)Everything else sees to it that you get no NA#! errors (when the property DOES NOT exist in Old Data) or "0" (when the property DOES exist in Old Data but with blank cells in Col K:R).
- That worked! Thank you so much!
