V-LookUp to see if the same number ID is found in two separate sheets

aaronvick40

Is there a formula that would check if the number ID in one sheet is also found in a separate sheet?

Paul Newcome

I would suggest a COUNTIFS. Nest that in an IF to say something along the lines of

=IF(COUNTIFS({Other Sheet ID Column}, @cell = [ID Column]@row)> 0, "output if true", "output if false")