bluepenink
Well-known Member
- Joined
- Dec 21, 2010
- Messages
- 585
Hello
Struggling to conquer this formula
so can someone pls help!
=INDEX(mySource,MATCH(E$7,$S$5:$S$160,0),MATCH($C$5,$T$5:$T$160,0),MATCH($C8,$U$4:$U$160,0))
mysource = all data ($S$3:$Y$160)
E$7 = P2 on my main table
$S$5:$S$160 = range where P2, P3...P12 is stored
then check for region i.e. Northeast, Southeast
$C$5 = US Northeast
$T$5:$T$160 = range where US Northeast, US Southeast etc is stored
and then match by criteria i.e. total deals, total revenue etc
$C8 = Total deals
$U$4:$U$160 = U4, Total deals, U5 to U160 sums # of deals for different regions i.e. 160
im getting 0 as my answer. i know my logic is not straight here, so can someone kindly help, thxs!
Struggling to conquer this formula
so can someone pls help!=INDEX(mySource,MATCH(E$7,$S$5:$S$160,0),MATCH($C$5,$T$5:$T$160,0),MATCH($C8,$U$4:$U$160,0))
mysource = all data ($S$3:$Y$160)
E$7 = P2 on my main table
$S$5:$S$160 = range where P2, P3...P12 is stored
then check for region i.e. Northeast, Southeast
$C$5 = US Northeast
$T$5:$T$160 = range where US Northeast, US Southeast etc is stored
and then match by criteria i.e. total deals, total revenue etc
$C8 = Total deals
$U$4:$U$160 = U4, Total deals, U5 to U160 sums # of deals for different regions i.e. 160
im getting 0 as my answer. i know my logic is not straight here, so can someone kindly help, thxs!
