I need your help. See attached sample file.
On Sprint tab, add formula to column B
Lookup Site ID of Col A from AD tab Col A
Find associated row that matches "office Manager"
then return associated email from column D
See sample entries.
Same for "General Manager" in Column C of Sprint tab.
Gary - Cincinnati