Worksheet 1 is called All Staff
Worksheet 2 is called TEAM 1
Worksheet 3 is called TEAM 2

All Staff A B
C
LOCATION EMPLOYEE # EMPLOYEE NAME
1
JOHN SMITH
2
RAY SMITH

TEAM 1 A B
LOCATION EMPLOYEE NAME
DOWNTOWN OFFICE JOHN SMITH

TEAM 2 A B
LOCATION EMPLOYEE NAME
CENTRAL OFFICE RAY SMITH

I would like a formula to gather the location for each employee and return
it to the All Staff worksheet. Thank you


--
Newfie