Frank Kabel wrote:
*Hi
no need for VBA: Enter the following in D1:
=VLOOKUP(C1,$A$1:$BB$100,2,0)
and copy down

--
Regards
Frank Kabel
Frankfurt, Germany


Hello,

As a new learner of VBA, I’m having a very hard time with this.
I’m
trying to see if any cells in columns 1 and 3 are duplicates o
each
other. If so, I need for the value of the cell in column 2, i
the
same row, next to the matching cell in column 1, to be copied into
column 4, in the same row as the matching cell in Column 3. Colum
1
will have more entries than column 3.

In example, this is what it the spreadsheet would look lik
befo

Acc # Name Acc# Name
163 Mark 597
744 Pam 917
682 Eric
917 Sara
597 Mike
753 Liz

And, hopefully, it will copy and paste the matching values o
column
2
into column 4, so it would look like this:

Acc # Name Acc# Name
163 Mark 597 Mike
744 Pam 917 Sarah
682 Eric
917 Sara
597 Mike
753 Liz

The actual spreadsheet will be much longer. Thank you so much in
advance. I’m having a very hard time getting past this.

Chad


---
Message posted from http://www.ExcelForum.com/ *


Thank you so much! That worked perfectly.

Chad :

--
Message posted from http://www.ExcelForum.com