Formulas Excel assistance

Copper Contributor

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.

7 Replies
Hello,

You didn't attach any file to understand the question

@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. 

how to attach the file that i want show you my example
I just upload the files for example.. let me know.
I been wait please help me!

@DEAF_DWJr98 

 

Hard without seeing the workbook but you could try using this, in cell C1 of Sheet2:

 

=IF(B1=Sheet1!B1, Sheet1!B1, "")

@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.