Hello,
I'm making a quote form that has a column for Products, Descriptions, and Prices. I have set up the Products column to pick a product from a drop down menu. I want to make it so that the Description and Price column will automatically be filled in when a product is selected from the Products drop down menu. The Prices column works fine but the Descriptions column only displays the formula " =INDEX(Description,MATCH(D21,Products,0))". When Entering the formula the appropriate columns of the data table were highlighted. Does anyone have any suggestions?
Thank you.
Bookmarks