I have followed tutorials I found using Google in trying to improve how my sheet works but all I can find seems to be working for a horizontal movement between cells and my data runs vertically. I have a list of barcodes, column A sheet "transactions" and next to that, column B a list of item descriptions. Column C is a column for Variants because sometimes an item has the same barcode but is different in some way (for example, there are items of different colour all under the same barcode, so the description is the same but the variant for "yellow", "blue", or "green" is what makes the entry unique for stock counting purposes).
What I would like to do is make the variant column a dropdown menu, with relevant selections for the barcode that is scanned into column A of sheet "sales". This would mean that when a barcode is scanned that contains no variants, there are either no options in the dropdown, or there is no dropdown menu available but when there are variants available for that code, the dropdown menu shows only options that are relevant to that barcode.
I'm flexible with my database at this point, so if the solution requires that all non-variant cells be empty for example, I can arrange that but at the moment a product without a variant contains a 0 in the variant column.