Forum Discussion

excel_learner's avatar
excel_learner
Brass Contributor
Jan 07, 2022

IF Statement not working

I'm trying to put a formula together that's based on select criteria in the same row. This is linked to another table called Reference table. In the Master I want to get values in category column AD ...
excel
Formulas and Functions
  • excel_learner's avatar
    excel_learner
    Brass Contributor
    Jan 07, 2022

    OliverScheurich I am trying the same formula on my sheet but its not working for some reason.

    Any reason why that could be?

    Also why do you have this { before equals and at end of formula.

     

    • OliverScheurich's avatar
      OliverScheurich
      Gold Contributor
      Jan 07, 2022

      excel_learner 

      When you filter the "Master" sheet as shown in the attached file you can see which banding entries cause the NV errors. For example the entries in cell Y2 of the "Master" sheet ( 4-5” ) and in cell B33 ( 4-5ˮ ) of the "Reference Table" sheet are different. This is not obvious but ” and ˮ are different and therefore the formula returns the NV error which is absolutely correct.

       

      The solution is to copy the value of cell Y2 of the "Master" sheet and then paste it into cell B33 of the "Reference Table" sheet. Immediately the formula returns CI/SI/DI LP 4"-5" in cell AD2 of the "Master" sheet.

       

      Then copy <=3” and 4-5” from the "Master" sheet and paste them accordingly into the cells (B2, B3, B6, B7, B11, B12  and so on) of the "Reference Table" sheet.

Resources