Apr 05 2020 05:33 PM - edited Apr 05 2020 06:08 PM
That on a sheet column b if it matches the data on a different sheet column b, then it needs to copy then if not, do not copy.
Apr 05 2020 05:42 PM
Apr 05 2020 05:49 PM
@Abiola1 I am trying match from this sheet 1 on column B where same order ID on another sheet 2 on column B. I not have to look up the order id then copy from column D to i to fill out on Sheet 1 to column K to P if Order ID matched.
Apr 05 2020 06:01 PM
Apr 05 2020 06:09 PM
Apr 12 2020 01:40 PM - edited Apr 12 2020 01:42 PM
Hard without seeing the workbook but you could try using this, in cell C1 of Sheet2:
=IF(B1=Sheet1!B1, Sheet1!B1, "")
Apr 12 2020 09:46 PM
@DEAF_DWJr98 Perhaps like in the attached file? None of the orders on the first sheet matched the ones in the second, so I copied some data there to test a solution with VLOOKUP. If you are on the latest version of Excel you might want to have a go at it yourself with XLOOKUP.