Cross referencing Sheet-formulas
I want to look up the requestor name ,Department rep,Department Rep(second if applicable) for each Tracking ID from another sheet which contains the names of these department reps.
If a department name is entered the corresponding column should return the name of the rep from the other sheet.
Which is the best function to use:
-IF Formula so it can return only that dep rep name?
Pls advise how this could be achieved.
Help Article Resources
Check out the Formula Handbook template!