Comparing Columns

**ryanb4614** · 07-14-2010, 10:48 PM

Distributor A has all weights and UPC (upc in 1 column and weights in another)
Distributor B has is missing weights and may not have the all the same product/upc they may have more/differ etc.

I need to...
If distributor A and B have the same upc I need Distributors A weight to go into Distributors B weight column IF there is a 0. I needs to go into distributor B column that is already there. So basically its taking the information from distributor A column if the upc match and replacing the 0. But if there is not a 0 and upc still match it does nothing.

So 4 Columns all together can't make a seperate column. It needs to add into distributors B weight column if there is a 0 and has the same UPC as Distributor A

**martindwilson** · 07-15-2010, 02:57 AM

how about an example workbook?

**ryanb4614** · 07-15-2010, 06:31 AM

Here is an example. See attachment

**martindwilson** · 07-15-2010, 06:54 AM

you cant do that in the same cell ie if cell has a value you cant put a formula in there as well.
you need to copy cols a:b to somewhere and use vlookup on it
see attached