Lookup with AND i think
soory for not coming back earlier but i have had my assignments
I'm still not sure whether i'm following you
here is what i've come up with:
=IF(A13="Retail Direct",OFFSET(INDIRECT("C"&MATCH("Retail Direct",$A
$1:$A$8,0)),MATCH(B13;$B$1:$B$6,1)-1,),IF(A13="Distributor",OFFSET
(INDIRECT("C"&MATCH("Distributor",$A$1:$A$8,0));MA TCH(B13,$B$7:$B
$8,1)-1,)))
with your data on actual sales volumes in A13 and lower
and your table "Sales Group Sales Value TM Calls" in A1:C8
adjust yr ranges to suit
untested
if this does not work then pls send me your workbook
On 5 Lis, 15:53, "Mattlynn via OfficeKB.com" <u44078@uwe wrote:
maybe i can email you the spreadsheet??????
Jarek Kujawa wrote:
sorry, you seem to have delivered sufficient info
will get back to you later
Hi Jarek
Thanks for replying - will try and make less vague
[quoted text clipped - 33 lines]
Message posted via OfficeKB.comhttp://www.officekb.com/Uwe/Forums.aspx/excel-functions/200911/1
--
Matt Lynn
Message posted viahttp://www.officekb.com
|