Monday 15 September 2014

Excel Formula for Comparing 4 Columns but Treating 2 Columns together? -


I'm trying to compare 4 columns (or 2 columns in each sheet).

Whether the SKU has changed for the price or not the data is sorted, so that the range should be from the column.

I get an error in using the formula below ...

IF (COUNTIF ("a: a" & Amp; "b: b", " or

= IFERROR (INDEX A: B, match (A1, A) : A, 0)), "", " but the data is not always sorted 

  column (A + B) column (C + D) SKU value SKU value AAA 59.95 DDD 12 9.99 BBB 49.95 BBB 15 9.00 CCC 49.95 CCC 159.00 CGC DDD 12 9.99 AAA 59.99    
 
 
  = IF (VLUKUP (C1, $ A $ 1: $ B $ 4,2, False) = D1, "itemprop =" text "", "changed" )    

 








Posted by



at

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)