If Formula with multiple criteria

[COLIN_303]

Hi All

I am currently using the below if formula, to alert me when a delivery to one of the stores is over a certain size.

Please Login or Register  to view this content.

I have been tring to make the formula apply to 6 different stores, with out the need to edit each time, the stores also have different criteria

Poole >=4
Barnstaple >=12
Paignton >=4
Taunton >=10
Bridgwater >=10
Exeter >=10

any help with this would be great

kind regards
colin

[COLIN_303]

Please Login or Register  to view this content.

managed to get a little be further, but now stuck on the last bit

[Fotis1991]

Perhaps...

=if(or(and(c4={"Paignton","Barnstaple","Taunton","Bridgwater","Poole"}),and(D4>=10)),"Alert","")

[Fotis1991]

bump...not registered....

[Ace_XL]

Maybe..

=IF(D3>=LOOKUP(C3,{"Barnstaple","Bridgwater","Exeter","Paignton","Poole","Taunton"},{12,10,10,4,4,10}),"Alert","")

[COLIN_303]

Great works! thank you