Help with function if on excel

Question

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 file it only gives me all true or all false, if do each individually then it seems to work.

see the file attached, any help will be appreciated.

Thanks,

Amanda

sergeibaklan · Answer

amandaramos&nbsp;
You may use
=COUNTIFS(H:H,$A2)&gt;0
to check if ID in one list is in another list

amandaramos · Answer

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

sergeibaklan · Answer

amandaramos&nbsp;
Please check it in column F in attached

amandaramos · Answer

SergeiBaklan&nbsp;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 · Answer

amandaramos&nbsp;
If so rows shall be inserted from column E (with formula) to column N.
&nbsp;
Or you may use formula
=INDEX(A:A,ROW())=INDEX(H:H,ROW())
see in column F attached.

Forum Discussion

Help with function if on excel

5 Replies

Resources