Comparing Columns, Then copying data

[jdb]

I have two worksheets.

The first is called Master list. Each row is unique...the first field is a
unique ID number, the second field is a name.

The second worksheet is called Orders. Each row is NOT unique, the first
field is a name.

I want to add the unique ID field from Master List to each record in Orders.

So, I think I want to compare the name in Orders to the name in Master List
and, if they are equal, copy the ID number to a new column.

But I have no idea how to do that. I've tried if statements, but cannot get
it right.

Please help.

Thank you.


--
Joe

[CLR]

One way would be to insert this formula in cell C1 of the Master List sheet
and copy down as far as you have data in columns A and B.....

=VLOOKUP(B1,Orders!A:A,1,FALSE)

Then, do Copy > PasteSpecial > Values on Column C.....
Where you have values in column C are the rows where you have exact matches
between the two lists...........then manupulate the data to suit........

hth
Vaya con Dios,
Chuck, CABGx3



"jdb" wrote:

>
> I have two worksheets.
>
> The first is called Master list. Each row is unique...the first field is a
> unique ID number, the second field is a name.
>
> The second worksheet is called Orders. Each row is NOT unique, the first
> field is a name.
>
> I want to add the unique ID field from Master List to each record in Orders.
>
> So, I think I want to compare the name in Orders to the name in Master List
> and, if they are equal, copy the ID number to a new column.
>
> But I have no idea how to do that. I've tried if statements, but cannot get
> it right.
>
> Please help.
>
> Thank you.
>
>
> --
> Joe