2 Sheets needing to compare and extract different data

[kimee]

I have 2 data sheets that have the data with one having more (Online Shop vs Physical Shop Stock)

- I want to write a formula that looks at both and using a unique cell value (stock code) that they both have then look to see if the other data matches exactly (Sales Price) if yes ignore, if no Copy the Row to a new worksheet. Also compare another Cell (Stock on hand) in both Sheets and make sure the Sheet (Physical Shop) is always greater by a minimum of 2, if not add to new worksheet as before.

The 'Physical Shop" has about 3000 rows but only 5 columns in each worksheet.

Code	Description	Barcode	GSTPrice1	OnHand
A1001	2 SLICE TOASTER BLACK WESTINGHOUSE	9338620006562	89.95	0
A1002	2 SLICE TOASTER RED CIRCULON TRADITIONAL	51153566981	99.95	0
A1003	2 SLICE TOASTER WHITE WESTINGHOUSE	9338620006586	89.95	0
A1004	4 SLICE TOASTER S/S WESTINGHOUSE	9338620006616	99.95	-1

End result should shown me where the errors are (Prices don't match) (Inventory to high online)

thanks

Kx

[#2]

@kimee 

Hi I have created a sample document for you in which I have solved your requirements with the FILTER() function. Have a look at the document and see if it can solve your problems.