How can I replace text with a specific number?
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 |
How can I replace text with a specific number?
On Jul 3, 2:01*pm, 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 why not try vlookup? |
How can I replace text with a specific number?
"Nayab" wrote: On Jul 3, 2:01 pm, 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 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 |
How can I replace text with a specific number?
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 |
All times are GMT +1. The time now is 12:46 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com