I am currently trying to create a spread sheet for my company that in column A is the customer name. Column B is the reason why they are at the store. My goal is when they type in either 'Sales' or 'Repair' it will take them to another sheet that will go to the department in control of the needed function.



I tried the IF formula and the OR formula and could not figure it out. Please help me out if you could help me with giving me a link to a video doing this action or a formula I can copy and paste and just change the cells I need.Thank you.