I have a grid of data that shows all the products I can order in the columns across the top and all the options I can order with those products in the rows down the side. In the middle shows the price of the options (£x), whether it is already a standard fit (Std) or if that option isn't available for that product (N/A).
On another worksheet I have created an order form template where I can select the product from a dropdown list and as many options as I'd like fitted to the product in the cells below with each cell having a dropdown to select the options.
What I would like to do is have the price of each option or whether it is a standard fit or not available appear in the cell immediately to the right of the option I've selected, i.e. I would like it to read the grid and select the info based on the product/option. Is that possible please?
On another worksheet I have created an order form template where I can select the product from a dropdown list and as many options as I'd like fitted to the product in the cells below with each cell having a dropdown to select the options.
What I would like to do is have the price of each option or whether it is a standard fit or not available appear in the cell immediately to the right of the option I've selected, i.e. I would like it to read the grid and select the info based on the product/option. Is that possible please?
