Match Columns

[bigjoe]

Hi there,
Sorry if this has been answered before but I can’t find it anywhere.

In column 1 I have a list of products code I sell.
In column 2 I have my buy price.
In column 3 I have all the products supplied by my supplier.
In column 4 I have my supplier’s prices.
Column 3 has a lot more products than I sell.

What I want to do is match the products in column 1 to the products i
column 3. Than I would like to delete the products that don’t matc
with their prices.

I hope I have explained myself properly.

Thanks
Bigjoe

 

[Pete_UK]

I assume you have a heading in row 1, so that your data starts in row
2. Enter the word "Check" in E1 and in E2 enter this formula:

=IF(ISNA(VLOOKUP(A2,C$2:C$5000,1,0)),"delete","keep")

Copy this formula down to the bottom of your data - I have assumed your
supplier has 5000 product codes, but you can change this if you need
to.

You can then apply a filter to column E, selecting the value "delete",
so that only these rows are visible and this will enable you to delete
the contents of the cells in column C and D. Remove the filter and
delete column E. You will have a lot of gaps in C and D - you can
easily bunch these up by sorting these 2 columns only.

Hope this helps.

Pete

 

[bigjoe]

Thanks for the reply Pete. I will try this When I get back to work.
By for now.
Bigjoe