Hi Jarek
Thanks for replying - will try and make less vague
The sales data are ranges ....could be £5 up to £1M.
Against each rang of sales are different categories - Retail Direct,
Distributor, Trade, Wholesaler etc, and each category has a range of sales
values that determine the number of time a rep calls to that customer.

So on the main table, if say Wholesaler has a sales value of £5000, then i
need it to firstly look in the formula table to find WHolesaler, then
determine the sales value range and return the call value.

Say i had category in Col A, sales value in Col B and calls in Col C then I
know that in Col D i could put =lookup(D2,B:C) would return the calls value,
but i am stuck as to how to say to make sure the category would also match.

Does this make more sense ?
thanks
Matt



Jarek Kujawa wrote:
your explanations are a bit vague
in no row of yr data are sales value 25500 when A=Retail Direct
same with A =Distributor, and Column B = 200,000

you surely are not looking for sth. like:
=IF(AND(A1="Retail Direct",B1=25500),6,IF(AND
(A1="Distributor",B1=200000),25))
?
Another way of saying this is...

[quoted text clipped - 37 lines]

- Pokaż cytowany tekst -

--
Matt Lynn

Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...tions/200911/1