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