Combine 2 sheets into one
I have 2 sheets, one with customer location data and one with parcel attributes. I would like one sheets that has the data from both sheets using the parcel number to match the information. (It is listed as Parcel # on one sheet and External System Link on the other sheet.) I am not even sure how to attempt this. Is it even possible? I hope I don't have to do it manually as there are approximately 3000 rows of information. I have uploaded the sheets to show the different columns but left the column data blank for privacy.
Help Article Resources
Check out the Formula Handbook template!