software

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 A785Please help.

Sincerely,

PaolaAndrea


In C1 put

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

and formula copy this down the column.

--PaolaAndrea Wrote:
gt; I have two spreadsheets, one contains all the job names with the old
gt; job
gt; number.
gt; The second contains the old job numbers with the new job numbers.
gt; I need a formula that will look up the old job numbers and return the
gt; new
gt; job number in the cell next to it.
gt;
gt; Example:
gt; Spreadsheet with old job numbers
gt; colunm A Colum B
gt; Geneva 123
gt;
gt; Column A Column B
gt; 123 A785
gt;
gt; Results after formula
gt; Column A Column B Column C
gt; Geneva 123 A785
gt;
gt;
gt; Please help.
gt;
gt; Sincerely,
gt;
gt; PaolaAndrea--
Bryan Hessey
------------------------------------------------------------------------
Bryan Hessey's Profile: www.excelforum.com/member.php...oamp;userid=21059
View this thread: www.excelforum.com/showthread...hreadid=533055