I am creating a simple Point of Sale System for a store using an excel/libre office spreadsheet.
The spreadsheet has a sheet called "Inventory" which has the following columns:
This holds data like:
- Scrabble - $5
- Monopoly - $10
- Drink - $1
- Ice-cream - $2
- (etc, about 500 entries total)
It has another sheet called "Product Sales", which has two columns:
The first column "Item" uses cell validation to create a dropdown box that lets me choose from all of the names defined in "Inventory" (column 1).
I would like for "Product Sales".Price to automatically update to the appropriate Inventory.Price when "Product Sales".Item is changed.
The only way I can think to do this right now is with a huge, unwieldy, hard to edit, and bug-prone if statement. Another way to do it would be with a for() loop, but I can't do that.
Is there some other method I'm not aware of?