Forum Discussion
Excel IF and OR
Hello I am trying to insert a formula: I need text entered into a cell if cell A2 is administration then add Peter, or if cell A2 is Education then add John etc etc. I basically want to add the ...
SelenaJane73 Although nested IF functions or IFS will work, you may want to avoid hard-coding all departments and manager names into the formula. Consider using a lookup table and use XLOOKUP or VLOOKUP (to name a few) to dynamically match the Department with the Manager as demonstrated in the attached file.