Help with COUNTIFS formula

aaronvick40

Hello all,

I am looking for some assistance with a COUNTIFS formula. I have two columns of large data sets (staff ID numbers), one outdated and a new one representative of the current organization. My goal is to cross reference the two and see which IDs appear in both lists and which do not. I originally started playing around with a V-LookUp formula but received feedback that the below formula may be a better option:

=COUNTIFS([Staff Info ID]1:[Staff Info ID]3147=[RNs List ID]1:[RNs List ID]3332)>0, "output if true", "output if false"

I keep receiving error messages when inputting the above formula. Any help would be greatly appreciated!

jpaul

assuming that [staff info ID] is the new ID numbers you are using and you want to see if those numbers appear in the old [RNs List ID] list.

=Countif([RNs List ID]:[RNs List ID],[Staff Info ID]@row)

Anything above 0 appears in both list. If you want it to return a statement just add =IF with it

=IF(Countif([RNs List ID]:[RNs List ID],[Staff Info ID]@row) >0,Yes,NO)