Help in data comparison

[ansi_11111]

I have a worksheet contains items serials and distributors (serial, distributor) and I have a worksheet with the sold items serials and customers (serial, customer name). I want to comapre the serial in the second sheet with the first sheet to know the distributor who sold this item, so the result will contain the sold item serial in a column and the seller distributor in the second column!!

Any one will help.

[Marcelo]

Hi, Ansi,

Worksheet 1
Column A B
1 serial distributor
2 0123 A&Co
3 0456 B&Co

Worksheet 2
Column A B C
1 serial Customer Distributor
2 0123 John A&Co
3 0456 Mary B&Co

try to use a formula in C2 as:
Vlookip(A2,worksheet1!A2:b3,2,0)

Chnage on the "worksheet1!A2:B3" to the name of your WS and the range as
your convenience

hope this helps
Regars from Brazil
Marcelo












"ansi_11111" escreveu:

>
> I have a worksheet contains items serials and distributors (serial,
> distributor) and I have a worksheet with the sold items serials and
> customers (serial, customer name). I want to comapre the serial in the
> second sheet with the first sheet to know the distributor who sold this
> item, so the result will contain the sold item serial in a column and
> the seller distributor in the second column!!
>
> Any one will help.
>
>
> --
> ansi_11111
> ------------------------------------------------------------------------
> ansi_11111's Profile: http://www.excelforum.com/member.php...o&userid=35220
> View this thread: http://www.excelforum.com/showthread...hreadid=549908
>
>

[ansi_11111]

Thank u for your help Mr. Marcelo (vlookup).