Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
FIND SPECIFIC TEXT AND REPLACE IT | Excel Worksheet Functions | |||
replace or substitute a letter for a specific number | Excel Discussion (Misc queries) | |||
replace letter of alfanumeric value by a specific number | Excel Discussion (Misc queries) | |||
Replace a number with text | Excel Worksheet Functions | |||
Replace Number with Text using Macro | Excel Discussion (Misc queries) |