lookup with offset?
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
|