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
-
Do you have a table built out already that has each Tracking ID in one column and the corresponding Department Rep in another column?
Categories
- All Categories
- 14 Welcome to the Community
- 10.7K Get Help
- 63 Global Discussions
- 68 Industry Talk
- 385 Announcements
- 3.5K Ideas & Feature Requests
- 55 Brandfolder
- 125 Just for fun
- 50 Community Job Board
- 464 Show & Tell
- 40 Member Spotlight
- 44 Power Your Process
- 28 Sponsor X
- 234 Events
- 7.3K Forum Archives