I have an Excel spreadsheet which contains the names of 8 types of fabrics. There are 4 colors of each fabric and each fabric is 10m meters in length. The price of each fabric is listed in a different cell in 50 cm increments starting from 1 m. So in essence there are 19 different prices for each fabric, and in total, 608 cells with different prices for all fabrics (8 types X 4 colors X 19 sizes = 608)
I created a worksheet Where users input the Size of the fabric and the Type of the fabric as below.
Cell A1 - Input the type of the fabric (8 options)
Cell A2 - Input the color of the fabric (4 options)
Cell A3 - Input the size of the fabric (19 options, 100-150cm, 200-250cm etc.)
Cell A4 - This cell will display the price.
I need a formula that will display the price of the fabric in Cell A4. Note that the prices can only be displayed in cell A4. No other cell in the worksheet can be used to show prices. The only option i can think of is to use an =IF(AND( statement but with 608 different prices that would take a day to write.
Any ideas to save me the trouble of writing the =IF(AND( formula will be appreciated
Bookmarks