Hi gurus

i'm stumped on this and i'll try to explain what i'm trying to achieve, but have uploaded a simplified version as well if my explanation is poor.

I capture external data in to Range A1:A50 of numbers , this data changes every minute or so, but sometimes a lot quicker

In Range B1:B50 is a formula crunching numbers in Range A1:A50.

In range C1:C50 is a formula to get a match result if reaching a criteria e.g If B6 value is >5 and < 10 "match"

The problem is as the values in column A6 changes the word "match" comes and goes in column C6

So in column D6 i want to paste the __value __"match" if it appears in column B so it stays in place in D6 whether it stays in C6 or not.

I gather it will be a trigger event in worksheet code rather than a macro, but from here i'm stuck.

Appreciate any help

Thanks in advance

dunc