Look up and return a value

[PaolaAndrea]

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

 

[Bryan Hessey]

In C1 put

=VLookup(B1,Sheet2!A:B,2,False)

and formula copy this down the column.

--