Thread
:
Find matching values in two different columns
View Single Post
#
4
Posted to microsoft.public.excel.worksheet.functions
lmarstin
external usenet poster
Posts: 4
Find matching values in two different columns
Column 1 contains an email address which needs to match the email address in
column 2. Column 3 contains the organization code for the addressee.
Example:
4545
The email addresses in both columns do not line up with each other in the
same row and I don't want to have to drag and drop 1000 or so org codes.
"John C" wrote:
What defines corresponding value? In other words, after you find the match in
column 2 for the value in column 1, what is the corresponding value based on?
--
John C
"lmarstin" wrote:
I have 3 columns. I need to take the value in column 1 and locate the
matching value in column 2 and then write the corresponding value in column 3
to a new column.
Reply With Quote
lmarstin
View Public Profile
Find all posts by lmarstin