=COUNTIF - formula issues - when value shows in one cell, show certain value in another cell

=COUNTIF - formula issues - when value shows in one cell, show certain value in another cell

Hello,

I have used "=IF(COUNTIF)" formula successfully in one workbook to look to see if cell D15 contains "plasterboard - 2.4m" and if it does to show "2.88" in cell E15. I then managed to add additional keywords to look for which would display different data in cell E15.

As an FYI cell D15 is linked to a product list table on a separate tab, so when you start typing it will find what you need from the table.

I have copied the formula over to a new workbook and now it does not work.

The below is what I have copied over. I have also shared the sheet with support but not sure how I send a follow up message.

The formula I used is below:

=IF(COUNTIF(D15;"*PLASTERBOARD - 2.4m*");"2.88";IF(COUNTIF(D15;"*STUD - 2.4m*");"2.4";IF(COUNTIF(D15;"*PLASTERBOARD - 2.7m*");"3.24";IF(COUNTIF(D15;"*STUD - 2.7m*");"2.7";IF(COUNTIF(D15;"*PLASTERBOARD - 3.0m*");"3.6";IF(COUNTIF(D15;"*STUD - 3.0m*");"3.0";IF(COUNTIF(D15;"*STUD - 3.6m*");"3.6";IF(COUNTIF(D15;"*STUD - 4.2m*");"4.2";IF(COUNTIF(D15;"*TRACK - 3.0m*");"3.0";IF(COUNTIF(D15;"*BAR - 3.0m*");"3.0";IF(COUNTIF(D15;"*PLATE - 2.4m*");"2.4";IF(COUNTIF(D15;"*MF5*");"3.6";IF(COUNTIF(D15;"*MF6A*");"3.6";IF(COUNTIF(D15;"*MF7*");"3.6";IF(COUNTIF(D15;"*25mm x 25mm Suspension Angle - 3.6m*");"3.6";IF(COUNTIF(D15;"*50mm x 25mm Suspension Angle - 3.6m*");"3.6";IF(COUNTIF(D15;"*PIR Insulation Board - 2.4m x 1.2m*");"2.88";IF(COUNTIF(D15;"*PIR Insulated Plasterboard - 2.4m x 1.2m*");"2.88";IF(COUNTIF(D15;"*Clamping Strip - 2.7m*");"2.7";IF(COUNTIF(D15;"*Clamping Strip - 3.0m*");"3.0"))))))))))))))))))))

    Nederlandse Hulpbronnen