Lookup matching values

[hmirones]

I have 2 spreadsheets with several columns.
On spreadsheet 1 I have
Column A: ID
Column O: Compensation Rate

On Spreadsheet 2:
Column A: ID
Column D: Compensation Rate

I want it to lookup by the id the compensation on Spreadsheet one.

Thanks for the help

 

[Joe4]

Looks like you already have the LOOKUP table, so you can probably just use VLOOKUP.
See: https://www.techonthenet.com/excel/formulas/vlookup.php

 

[hmirones]

I have tried using Vlookup but with no luck, can you help me with formula example, im very bad and building vlookup formulas.

 

[Joe4]

What is the name of your two sheets?
Which one is the one you are looking up?

 

[hmirones]

Spreadsheet 1 is the one Im looking up the information.

 

[Joe4]

OK, assuming that your sheets are named "Sheet1" and "Sheet2", then if you are looking up a value in cell A2 on Sheet2, place this formula in cell D2 on Sheet2:

=VLOOKUP(A2,Sheet1!A:O,15,0)