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" )
No comments:
Post a Comment