Hi,
Would someone help me?
I need to enter this formula below in a group of cells with a script Im using, However I need to enter Ctrl Shift Enter to make it work correctly.
Cells(i, 2).FormulaR1C1 = _
"=IF(ISNUMBER(MATCH(RC[-1],'UPC Verification'!R2C1:R10000C1,0)),INDEX('UPC Verification'!R2C2:R10000C2,MIN(IF(ISNUMBER(MATCH('UPC Verification'!R2C2:R10000C2&'UPC Verification'!R2C1:R10000C1,Order!R6C1:R30C1&RC[-1],0)),ROW('UPC Verification'!R2C1:R10000C1)-ROW('UPC Verification'!R2C1)+1))),"")"
Thank You, Mike
Bookmarks