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...!