Forum Discussion

jberlin's avatar
jberlin
Copper Contributor
Jan 03, 2020

Request For If Then Function Help

Hello, I would like to do an IF function to add a "yes" or "no" column based on if a cell's text matches the text on another sheet.   This is what I have right now: IF($A2=Sheet2!A:A,"yes","no"). T...
Formulas and Functions
SergeiBaklan's avatar
SergeiBaklan
Diamond Contributor
Jan 03, 2020

jberlin 

If yes in case if A2 is equal to any cell in Sheet2!A:A, when

=IF(COUNTIF(Sheet2!A:A,A2),"yes","no")

 

  • jberlin's avatar
    jberlin
    Copper Contributor
    Jan 03, 2020

    SergeiBaklanthank you so much for your help -it worked!