I hope I can explain this right.
I have sheet named " Summary" and sheet name "District" and looks like this

Summary:

NAME Incoming

Tim (need some kind of formula here)
Bob (need some kind of formula here)
Jennifer (need some kind of formula here)


District:
Column A B C
D


1 Call Type Direction Total Calls
2 TIM
3 Incoming
4 Internal 2
5 Local 7
6 National 11
7 Total 20

I want to somehow look up the name from the summary page in District Sheet,
if the name matched and bring the "total" value.
somehow look the name, go down 5 columns, then 3 rows to the left .

Thank you