Software·43,775 discussions

Using an “IF” Statement In Excel

Locked

I would like to use the “IF” statement between two spreadsheets. For instance I want A1 to say “Yes” if a2 of sheet one is the same as anything in a range of a2 through a100 of sheet two. Im using text not numbers to do this.

Thank you.

Topic

Reply To: Using an “IF” Statement In Excel

In reply to Using an “IF” Statement In Excel

=IF(COUNTIF(Sheet2!A2:A100,A2)>=1,”Yes”,”No”)

[Author]

Replies