I have two spreadsheets, one contains all the job names with the old job
number.
The second contains the old job numbers with the new job numbers.
I need a formula that will look up the old job numbers and return the new
job number in the cell next to it.

Example:
Spreadsheet with old job numbers
colunm A Colum B
Geneva 123

Column A Column B
123 A785

Results after formula
Column A Column B Column C
Geneva 123 A785


Please help.

Sincerely,

PaolaAndrea