Forum Discussion
Need help with Excel Formula
I have two sheets that have the same headers, A1 Address, B1 City, C1 State, D1 Site ID. Sheet Old has 775 items and Sheet New has 1205. I want to compare address between the two and place the iden...
Riny_van_EekelenGood suggestion. I have added the example in the attached file.
tviss64 Great! I'm on my way out now. Gladly leave it to someone else her to resolve. If not, I'll get back to you later.
Riny_van_EekelenThank you!
tviss64 This is something that would fit Power Query (PQ) very well. Especially if you have to do this regularly and on larger data sets. Created two structured tables from the Original and New data. Queried them and did three merges that load the desired records back to your sheets 3, 4 and 5. See attached workbook.
Are you familiar with PQ? If not, the site in the link below would be a good place to start.