Thanks that did help.

I was concerned what you did above was a mathmetical sum rather than
say a match:

So, say A=2 and C=3 and B=3 and D=2 with E 2 F 3. The match would be
with A&C

however, I tested it and with various values and it does work on Match
rather than sum. Thanks

I don't suppose you know an easy way of changing the value of the row
for the if statement. I could have upto 700 rows would I have to
manually change the value in each if?

Thanks again.