Find in sheet 2

  • Thread starter Thread starter Tammie
  • Start date Start date
T

Tammie

How can I choose a Cell in Sheet 1 and find out if what is
in that cell is also ANYWHERE in column G in SHEET 2?
For instance, the number "6" is in cell C1 of sheet#1, and
I want to know if "6" is anywhere in column G of Sheet #2
of the same workbook.

Thank you,
Tammie
 
One way:

=COUNTIF(Sheet2!G:G, C1)

will return the number of 6's in column G, given your example.

If you just want to return TRUE or FALSE:

=COUNTIF(Sheet2!G:G,C1) > 0
 
Thank you JE! This is perfect. I was looking for your
second "countif", but I think both will work even better!
 
Back
Top