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

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

Thank you!! yes, i meant 2 to the right. ;-)
it works like a charm!!
Thank you very much!

"bj" wrote:

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