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.

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.

Column 1 = A1:A10
Columns 2 and 3 = J1:K10

Try something like this:

=VLOOKUP(A1,J$1:K$10,2,0)

Copy down as needed.

--
Biff
Microsoft Excel MVP


"lmarstin" wrote in message
...
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.

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.

Thank you very much, worked great

"T. Valko" wrote:

Column 1 = A1:A10
Columns 2 and 3 = J1:K10

Try something like this:

=VLOOKUP(A1,J$1:K$10,2,0)

Copy down as needed.

--
Biff
Microsoft Excel MVP


"lmarstin" wrote in message
...
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.

You're welcome. Thanks for the feedback!

--
Biff
Microsoft Excel MVP


"lmarstin" wrote in message
...
Thank you very much, worked great

"T. Valko" wrote:

Column 1 = A1:A10
Columns 2 and 3 = J1:K10

Try something like this:

=VLOOKUP(A1,J$1:K$10,2,0)

Copy down as needed.

--
Biff
Microsoft Excel MVP


"lmarstin" wrote in message
...
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.