Please Help Combine to Two Lists

If Anyone could help it would be GREAT!

I have two lists with 3 columns and approximately 1500 row each
One List is for US and the other is for Canada

Column A = Product
Column B = Vendor
Column C = Code

I need one list that combines both of these list

Hopefully with two extra columns that indicates (this can be on a separate sheet)
Column E = US = X
Column F = Canada = X

If a Product with the same Vendor and Code appear in both list I only need it to show up once with a X in each of the US and Canada Columns. The X will be used for an auto filter later.


Any help would be appreciate
Thanks
Lostinformulas

you could just copy one list onto the bottom of the other and then sort the
whole lot
You obviously put the X onto the respective lists before you combine
them.When you sort thecombined list the duplicates will be next to each
other.
--
paul
[email protected]
remove nospam for email addy!



"lostinformulas" wrote:

>
> If Anyone could help it would be GREAT!
>
> I have two lists with 3 columns and approximately 1500 row each
> One List is for US and the other is for Canada
>
> Column A = Product
> Column B = Vendor
> Column C = Code
>
> I need one list that combines both of these list
>
> Hopefully with two extra columns that indicates (this can be on a
> separate sheet)
> Column E = US = X
> Column F = Canada = X
>
> If a Product with the same Vendor and Code appear in both list I only
> need it to show up once with a X in each of the US and Canada Columns.
> The X will be used for an auto filter later.
>
>
> Any help would be appreciate
> Thanks
> Lostinformulas
>
>
> --
> lostinformulas
> ------------------------------------------------------------------------
> lostinformulas's Profile: http://www.excelforum.com/member.php...o&userid=35229
> View this thread: http://www.excelforum.com/showthread...hreadid=566199
>
>

Thank you both it was most helpful. The formula worked great. Is there a way to add to the formula to delete the duplicate line???

=IF(AND(A2=A3,B2=B3,C2=C3),"x","")

Thanks Again.
Lostinformulas