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

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