Replacing multiple data from one worksheet to another?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Simon L - 02 Sep 2005 11:51 GMT

Ok lets try and explain what I want to do :confused:

I have a worksheet with some publication data in. Column A has th
email address in so JohnSmith@hotmail.com may show up 10 times becaus
he has 10 publications.

In another worksheet (in the same file) I have a key of email addresse
and Staff ID numbers. So JohnSmith@hotmail.com has a staff ID of 2468
What I need to do is replace the email address in the publication
worksheet with the Staff ID numbers in the key worksheet.

Any help greatly appreciated?? :

Reply to this Message

Dave Peterson - 02 Sep 2005 14:05 GMT

How about just inserting a new column (adjacent to the email addresses) and use
=vlookup() to return the staff id in that column.

You could even hide the email address column (or convert the formulas to values
and delete the original column).

Debra Dalgleish has some nice instructions for =vlookup() at:
http://www.contextures.com/xlFunctions02.html

> Ok lets try and explain what I want to do :confused:
>
[quoted text clipped - 14 lines]
> Simon L's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=3415
> View this thread: http://www.excelforum.com/showthread.php?threadid=401427

Signature

Dave Peterson

Reply to this Message

Simon L - 02 Sep 2005 15:54 GMT

Excellent thanks......that did the job!!

Signature

Simon L

Reply to this Message

aaron.kempf@gmail.com - 02 Sep 2005 23:33 GMT

yeah.. here is an idea..

instead of
a) copying data between sheets a zillion times
b) havnig files that are too large
c) having multiple copies of the same data (probably of having
differences between different copies is pretty high)

you shoud

1) keep your DATA in a DATABASE
2) report on your DATA using Views and Sprocs
3) use a real reporting program like crystal or access instead of
creating the report by hand every week

Reply to this Message

Simon L - 02 Sep 2005 14:35 GMT

:confused: :confused: :(

Signature

Simon L

Reply to this Message