Using IF Function to reference sheets

HI

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!

Thanks

Ranjini Walter

Answers