Forum Discussion

Budman36's avatar
Budman36
Brass Contributor
Jul 30, 2019

Removing "#NUM!" Error

I don't understand what I am doing wrong.  Can someone please help!  Working on office 365, and making a table to consolidate data, and remove spaces.  My formula works (as far as data), and I watche...
Formulas and Functions
SergeiBaklan's avatar
SergeiBaklan
Diamond Contributor
Jul 30, 2019

Budman36 

Better wrap your INDEX formula with IFERROR, i.e.

=IFERROR(INDEX(...),"")

 

  • Budman36's avatar
    Budman36
    Brass Contributor
    Jul 31, 2019

    SergeiBaklan 

     

    Thank you so much for responding.  Would I put my code in the "..." part of your example?  

     

    B.

    • SergeiBaklan's avatar
      SergeiBaklan
      Diamond Contributor
      Jul 31, 2019

      Budman36 

      =IFERROR(INDEX($E$2:$E396,.. till end of INDEX pat),""). Remove IF with conditions at all.

      • Budman36's avatar
        Budman36
        Brass Contributor
        Jul 31, 2019

        SergeiBaklan 

         

        OMG!!! Thank you so much!!!   That worked.  I was going crazy trying to figure that out.  Watching youtube videos, etc.   Hard to try and google an issue of coding when you can't explain what it is doing wrong!

         

        thank you soooo much and have an awesome day! 

         

        B. 

Resources