Hi Glenn
Thanks for all this.
I just cant get it to work out, may i send you the spreadsheet for you to
have a look for me.
Many Thanks
Matt


Glenn wrote:
You said the the category would be in column A and the sales value would be in
column B. In my formula, I referenced A1 for category and B1 for sales value.

=LOOKUP(B1,IF(Data!$A$1:$A$5000=A1,Data!$B$1:$B$5 000,""),Data!$C$1:$C$5000)
______^^^^____________________^^^^________________ ________________________

Thanks Glenn, but where does this formaul look at the actual sales value
reached by the customer.
[quoted text clipped - 14 lines]

=LOOKUP(B1,IF(Data!$A$1:$A$5000=A1,Data!$B$1:$B$50 00,""),Data!$C$1:$C$5000)

--
Matt Lynn

Message posted via http://www.officekb.com