Hi here's my issue:

Spreadsheet 1: List of 500 companies

Spreadsheet 2: List of 1200 companies in one column, with revenue in another.

Problem: I want to see if any of the companies in spreadsheet 1 are matched in the list in spreadsheet 2, and if they are then I want to insert the corresponding revenue from spreadsheet 2 next to the company name in spread sheet 1.

Any ideas?