try something like
=offset(indirect("District!A"&match(A2,District!B1 :B1000,0)),5,3)
ibn B2 in your Summary sheet
I think you meant 3 to the right.
if it is three ot the left, make it be "...-3)"
"GEORGIA" wrote:
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
|