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

Emma O''Shaughnessy wrote:

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

--

Dave Peterson