I have two spreadsheets that have values pulled from different Sources that I need to compare. I have one common identifier (County Name) I can use for comparison purposes. Spreadsheet 1 pulls the “Total Return” for County Name > Source A > Level 1 and Spreadsheet 2 pulls the “Total Return” for Country Name > Source A > Level 2.
There will be slight differences in the return values depending on the sources pulled from and I need to reconcile out these small differences. The problem is that sometimes there is different number of County Names in each spreadsheet (sometimes spreadsheet A has more and sometimes spreadsheet B has more). Therefore after I sort out by County Nameand then try to mathc up some rows in each won’t match as there are additional number of county's in one spreadsheet.
I have tried using vlookup in a third spreadsheet but am not having any luck getting my desired result
Spreadsheet 1
Column A County Name
Column B Source “A”
Column C Level 1 (same level as spreadsheet 2)
Column D Total Return
Spreadsheet 2
Column A County Names
Column B Sources “B”
Column C Level 1 (same level as spreadsheet 1)
Column D Total Return
Any help?
There will be slight differences in the return values depending on the sources pulled from and I need to reconcile out these small differences. The problem is that sometimes there is different number of County Names in each spreadsheet (sometimes spreadsheet A has more and sometimes spreadsheet B has more). Therefore after I sort out by County Nameand then try to mathc up some rows in each won’t match as there are additional number of county's in one spreadsheet.
I have tried using vlookup in a third spreadsheet but am not having any luck getting my desired result
Spreadsheet 1
Column A County Name
Column B Source “A”
Column C Level 1 (same level as spreadsheet 2)
Column D Total Return
Spreadsheet 2
Column A County Names
Column B Sources “B”
Column C Level 1 (same level as spreadsheet 1)
Column D Total Return
Any help?