I am creating a form which will act as an advertising purchase order. I want
the price to auto populate and am using If arguments to associate product
with price, i.e....=IF(A20="EPL",25,IF(A20="DB",59,0)). The problem I am
having is that each product can have five different prices according to the
area that the advertising covers. The areas are divided into zones,
megazones, super megazones, state and national buys. There are eight
different advertising products but literally hundreds of zones. If I can set
up a series of "IF" arguments that are dependent on two criteria, product and
zone, I'll have it licked I think. Any ideas?....cause I'm lost!

Thanks