Forum Discussion

amandaramos's avatar
amandaramos
Copper Contributor
Dec 06, 2019

Help with function if on excel

I am trying to compare two lists and see the records that match and doesn't match with if statement                        =if(A2=H2,TRUE,FALSE) however, when dragging down the formula to the whole...
excel
amandaramos's avatar
amandaramos
Copper Contributor
Dec 06, 2019

SergeiBaklan , I did as you suggested but once I drag the formula down, it gives me all false even for the ones that match

  • amandaramos's avatar
    amandaramos
    Copper Contributor
    Dec 06, 2019

    SergeiBaklan the issue that I am having is that when I insert lines to align the ids that are if both list, and then I click the formula to go the next rows it gives me only True or False...not sure why this happens. See the file attached

    • SergeiBaklan's avatar
      SergeiBaklan
      Diamond Contributor
      Dec 06, 2019

      amandaramos 

      If so rows shall be inserted from column E (with formula) to column N.

       

      Or you may use formula

      =INDEX(A:A,ROW())=INDEX(H:H,ROW())

      see in column F attached.

Resources