i have a spreadsheet designed for invoicing, my staff enter products via
validation lists, if the item selected is "wood" for example, can the cell
next to it automatically enter the price into it. If it possible how can
someone give me a simple example.

thanks pat