Excel look ups

[dap6c6]

I have two spreadsheets that I am trying to merge. example:

Spreadsheet A contains
operator ID
operator name
operator department

Spreadsheet B contains
operator ID
user entry error

I want to pull the user entry erro into spreadsheet A by the operator ID that is on both spreadsheets. In the past I did an =if statement but for somereason it isn't working for me.

Thanks..

[davegugg]

You should us a vlookup:

=Vlookup(OperatorID,tableinspreadsheetB,2,0)

Look at the Help for the Vlookup for more details and examples.