Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel comparison of two sheets
I have two sheets in one workbook. Each sheet has Column A = Name,
Column B = Address. I need help with either a formula or vba code that will run a comparison, making sure the addresses are correct or the same. Sheet 1 would be the 'master' and sheet 2 would be the secondary sheet. I would think I need something that checks sheet1 name in column A and finds that name in sheet2 then the address...does that make sense? The row count are not the same, but is around 1700, give or take in both sheets. If I use a formula, do I run the formula or insert it on column C? Any help would be appriciated. Thanks...! |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel comparison of two sheets
Assuming Sheet1 is the master, put this formula in C1 of the secondary sheet:
=IF(ISNA(VLOOKUP(A1,Sheet1!A:B,2,FALSE)),"name not found", IF(VLOOKUP(A1,Sheet1!A:B,2,FALSE)=B1, "Matched", "Not Matched")) Then copy-paste or fill-down to the last row of data. " wrote: I have two sheets in one workbook. Each sheet has Column A = Name, Column B = Address. I need help with either a formula or vba code that will run a comparison, making sure the addresses are correct or the same. Sheet 1 would be the 'master' and sheet 2 would be the secondary sheet. I would think I need something that checks sheet1 name in column A and finds that name in sheet2 then the address...does that make sense? The row count are not the same, but is around 1700, give or take in both sheets. If I use a formula, do I run the formula or insert it on column C? Any help would be appriciated. Thanks...! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Automatic comparison and uploading of data among 2 spread sheets | New Users to Excel | |||
creating matching lists between sheets for comparison | Excel Programming | |||
Comparison of 2 excel sheets and put ouput in a 3rd sheet | Excel Programming | |||
Comparison / Check Off between 2 excel sheets. HELP NEEDED! | Excel Worksheet Functions | |||
Comparison or two sheets | Excel Programming |