In C1 put

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

and formula copy this down the column.

--


PaolaAndrea Wrote:
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
------------------------------------------------------------------------
Bryan Hessey's Profile: http://www.excelforum.com/member.php...o&userid=21059
View this thread: http://www.excelforum.com/showthread...hreadid=533055