This is a two-fold question (I a not a programmer) but I really want to learn and i need help with barcodes. If/when I scan a barcode it enters the information on the left side (A2-A200). If say for some reason I want to go to a barcode that is random and click on it - it goes to the next column. I want it to search for the correct row (identical information) and match it up (i.e. E2 (serial number) matches A2 scanned (serial number). NOT E2 (serial number) matched to A100 (serial number). That is my big issue...I have tried the index, search, vlookup, xlookup, etc.
The second part if It's allowed....is B2-B200 I want it to change to YES and green if A2-A200 matches the (serial number) of E2-200.
Neither of these seems hard but I can't get it to work the way I want it too...
Thanks.