Discussion Locked
Using an "IF" Statement In Excel
0 helpful
1 reply
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
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.