It's really NOT another group. You are actually multi-posting which is
frowned on here. Most of us read the different sub groups.

--
Don Guillett
SalesAid Software

wrote in message
ups.com...
Thanks Don and Bill for your timely replies,

I particularly appreciate Bills recommendation of using a lookup table,
i agree that it would certainly be the way to go,

However here is a suggestion i received on another group and i thought
i should share it with you

=MIN(IF(ISNUMBER(FIND({"Canal","Lake"},C34:C201)), D34:D201))

Regards

Manosh