I hope I explain my problem fully
Below is my equation and it works fine, BUT
=IF((AND(A2="55mm",B2="MDPE",C2="SDR11",D2="LP")),Table!C3,"Error")
Cell A2, B2, C3 & D4 are all drop down lists
Cell E2 is where the result is shown
Send to Forum.jpg
As you can see I am currently getting a result, if I change cell A2 to 63mm (in the drop down list) the result in cell E2 changes to "Error" which is correct based on the current formula.
The result in cell E2 is taken from another worksheet (Table) Cell C3) within this workbook.
I have 24 different diameters in the Worksheet and they are all on in the drop down list.
So if I choose 55mm I get cell C3, if I choose anything else I get the result "error"
What I want the formula to do is if I choose 63mm in the drop down list it picks up Cell C4, if I choose 75mm it should pick up cell C5, some people will say just write a look up formula but it is not that simple, because if I change the drop down for SDR rating to 17.6 it needs to pick up a different cell all together, based on the diameter in column A.
I have tried writing the formula as =IF((AND(A2="55mm",B2="MDPE",C2="SDR11",D2="LP")),Table!C3,"Error"),IF((AND(A2="63mm",B2="MDPE",C2="SDR11",D2="LP")),Table!C4,"Error") but the cell E5 returns this error #VALUE!
Help
My drop down list and the worksheet table
Table.jpg
Dropdown Lists.jpg
Bookmarks