Duplicate entries

[bazbarrow]

I have two spreadsheets both with multiple columns. In both of the spreadsheets there is a column that contains a unique URL. I need to run a formula that will only leave ALL the data for the rows that contain the same URL in the URL column of both spreadsheets. Hope that makes sense. For more info: One spreadsheet contains data from all instagram posts containing a specific Hashtag and the other spreadsheet contains data from all instagram posts containing a mention of the instagram username. I need to pull a spreadsheet together that contains all the data for ONLY the posts (their is one post per row) that appear in both spreadsheets. One of the columns for each spreadsheet contains a URL field and the URL will be the same for the same post. Thanks Richard