- Inventory Items descriptions in colum A and their matching Items Barcodes in Colum B.
- I want to scan On Hand inventory Item Barcodes into Colum C and match them to their corrosponding Barcode in Colum B.
- If the On Hand Scaned inventory Item Barcode from colum C find a match in Colum B, then turn Colum C Green containing the scanned barcode number or display "Match" in Colum E, also print the matching barcode number in Colum D adajcent to it's message.
- If the On Hand Scaned inventory Item from colum C does not find a match in Colum B, then turn Colum C Yellow containing the scanned barcode number or display "Item Missing" in Colum E.
I made a slite change to my above requirements in order to print the scanned barcode number in the cell next to it's adjacent message. I currently don't have the Excel skill yet to pull this off but that's why I sign up, to become better!