Hello. I need to show a label based on a choice made by a user on a particular sheet.
For example, if a user chooses an item from a list in a sheet, the label shows the appropriate row data corresponding to the column where the data is kept.
Item: (user chooses from a list) On Hand: (the corresponding row data)
Vaccum Bags 6
Boxes of Gloves 9
Any pointers in the right direction would be most appreciated.