I need to compare a text list in Column A in Sheet #1 to a text list in Column C in Sheet #2 and then print the resulting text it found in Column B in Sheet #1.
For example:
Sheet #1
A | B
------------------+--------------------
microsoft | rr@microsoft.com
jimc | er@microsoft.com
gmail | don@gmail.com
hotmail |
Sheet #2
C
-------------------
rr@microsoft.com
don@hotmail.com
don@gmail.com
er@microsoft.com
empty@mail.com
I don't see from your example how any of the text in column A of sheet 1 would be found in column C of sheet 2.
However, the vlookup() function can do the process you are speaking of very easily. Have a look at the help for it.
Is your code running too slowly?
Does your workbook or database have a bunch of duplicate pieces of data?
Have a look at this article to learn the best ways to set up your projects.
It will save both time and effort in the long run!
Dave
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks