I needed to merge two spreadsheets that did not have a unique identifier that matched but they did have a column that was kind of in common so I did some formula craziness and got most of it addressed.