May 26 2022 12:22 PM
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 for exemple:
=IF(C4:C999="Travel";"-5";"0")
where C4:C999 is the collum with the VLOOKUP entries
Travel is the entry i want to relate to "-5"
May 26 2022 12:33 PM
SolutionMay 26 2022 12:34 PM
May 26 2022 12:35 PM
May 26 2022 12:33 PM
Solution