Using IF Function to reference sheets

Answered - Pending Review


Can I use the IF function to reference sheets to auto-populate the names of department reps for a particular tracking ID:

So if Tracking ID changes then the Department rep name should change correspondingly. So what is the best way to do it?

Need help on this!


Ranjini Walter


  • Paul NewcomePaul Newcome ✭✭✭✭✭

    Do you have a table built out already that has each Tracking ID in one column and the corresponding Department Rep in another column?

Sign In or Register to comment.