How can I replace text with a specific number?

[Emma O''Shaughnessy]

Hi,

I have two Excel spreadsheets and need to merge them together.

One is a list of company assets and the email address of the user the asset
is assigned to.

The second is a list of email addresses and the personnel numbers that match
them.

The information I actually need is the company asset linked to the personnel
number, so I somehow need to combine these sheets to provide me with that
information.

To complicate things, the email addresses and personnel number sheet
contains far more employees than the company asset and email address sheet
does as not every employee has an asset.

I am by no means an Excel expert, can anyone please help me work out a way
this can be done.

Thanks in advance.
Emma

 

[Nayab]

Hi,

I have two Excel spreadsheets and need to merge them together.

One is a list of company assets and the email address of the user the asset
is assigned to.

The second is a list of email addresses and the personnel numbers that match
them.

The information I actually need is the company asset linked to the personnel
number, so I somehow need to combine these sheets to provide me with that
information.

To complicate things, the email addresses and personnel number sheet
contains far more employees than the company asset and email address sheet
does as not every employee has an asset.

I am by no means an Excel expert, can anyone please help me work out a way
this can be done.

Thanks in advance.
Emma

why not try vlookup?

 

[Emma O''''Shaughnessy]

why not try vlookup?

Perhaps I should have been clearer about how little Excel knowledge I have!
How does vlookup work? I shall go and try and decipher the help files.

Thanks
Emma

 

[Dave Peterson]

Debra Dalgleish has lots of notes on =vlookup()"
http://www.contextures.com/xlFunctions02.html
and
http://contextures.com/xlFunctions02.html#Trouble