Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Lookup Vector > Lookup Value | Excel Worksheet Functions | |||
Formula checking multiple worksheets | Excel Worksheet Functions | |||
Lookup function w/Text and Year | Excel Worksheet Functions | |||
lookup, index, match, offset, etc. | Excel Worksheet Functions | |||
double lookup, nest, or macro? | Excel Worksheet Functions |