Forum Discussion
Formulas Excel assistance
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
- I been wait please help me!
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.
Hard without seeing the workbook but you could try using this, in cell C1 of Sheet2:
=IF(B1=Sheet1!B1, Sheet1!B1, "")
- Hello,
You didn't attach any file to understand the question- how to attach the file that i want show you my example
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.
- I just upload the files for example.. let me know.
