i was wondering if this is possible. i am tracking the location of certain
personnel at different times. the location is in row 15. times are listed
times are listed in column A. can i do a lookup for a control number in row
17 to return the value in row 15?

for example:
at 12noon, employee 15 was in location 6, but at 12:30, they were at
location 21. i wanted to create a tracking worksheet so that i can see all of
their locations throughout the day.