Check Off Returned Inventory

[RizlaUK]

Hi,

I'm using a barcode scanner app on my fone to populate an excel sheet with items that need to be scanned, and scanned again when they're returned. Each scan results in a new row. I'm hoping to find a way to tick off, or green up the items that have been returned, when they're scanned back. This would then show me very quickly the outstanding items. Could some suggest the best way to go about this please?

Thanks a lot.

Rizla

 

[sheetspread]

Vlookup

 

[RizlaUK]

So this is what the data looks like on a row when i initially scan the barcode;

Bag Number	Dect Kit 1	Dect 2	Dect Kit 3	Date Delivered	Date Returned
1	ATH060	ATHB078		25/01/2021
2	ATH157	ATHB157	TLB094	25/01/2021

And when i start scanning the kits back in;

2	ATH157	ATHB157	TLB094	25/01/2021	26/01/2021
4	ATHB091	ATH152		25/01/2021	26/01/2021

Can anybody give me a code example that would 'green up' or tick off Kit Number 2 on the first table when i scanned it back please?

Thanks a lot.

Rizla

P.S I should mention that some bags contain either 2 or 3 Dect Kit Units, that's why some are missing a third barcode scan under Dect Kit 3.