Forum Discussion

gandriol's avatar
gandriol
Copper Contributor
May 26, 2022
Solved

Function IF

Hello, I need help with this function. I'm trying to relate the IF function to a list with VLOOKUP entries. I want to know if certain entries of certain words appear on the list. I tried this...
  • SergeiBaklan's avatar
    May 26, 2022

    gandriol 

    Perhaps you mean

    =IF( COUNTIF(C4:C999,"Travel"),-5, 0)

Resources