# Complex =IF(AND( formula alternative

1. ## Complex =IF(AND( formula alternative

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

2. ## Re: Complex =IF(AND( formula alternative

You should consider uploading a demo file explaining what you are trying to achieve. It's a lot harder to read your message and properly understand what you need, let alone finding the best solution to achieve this.

3. ## Re: Complex =IF(AND( formula alternative

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

5. ## Re: Complex =IF(AND( formula alternative

Thanks for the file, unfortunately it does not have any prices in it.
I also suspect that the file is not really representative of your actual data.
Can you please supply an accurate representation of your data, the prices do not need to be your actual price, just something that looks similar

6. ## Re: Complex =IF(AND( formula alternative

Sorry about the prices. Yes i corrected the post so now you should be able to view the prices in the file.
Yes this is a dummy file. The original file would take a long time to explain as it contains a lot more data.

7. ## Re: Complex =IF(AND( formula alternative

Ok, thanks for that, try
Formula:
`Please Login or Register  to view this content.`

8. ## Re: Complex =IF(AND( formula alternative

You can also use:
Formula:
`Please Login or Register  to view this content.`

9. ## Re: Complex =IF(AND( formula alternative

This one works. Perfect Thanks

10. ## Re: Complex =IF(AND( formula alternative

Both work perfectly thanks!!!

11. ## Re: Complex =IF(AND( formula alternative

You're welcome & thanks for the feedback

12. ## Re: Complex =IF(AND( formula alternative

There are currently 1 users browsing this thread. (0 members and 1 guests)