Hi there,

its probably best I give you an example.

A1 contains the following text

Australia & New Zealand Banking Group Ltd Ordinary dividend on 3750 shares at 62.00 cents

B1 contains $2,325

in C1 I want a formula that says.....if A1 contains both Australia and 62.00 I want the result to be B1

Your help is much appreciated.

cheers