Phew. 🙂

Nice job Velouria!

Greetings Velouria,

Thanks for your assistance the other day. You have made my job a lot easier ever since. Everything is working perfectly okay.

Meanwhile, I will be needing your help once more on this project.

Before now, we have been looking for number relationships in multiple cells of a row. What I need now is to be able to check if any number relationship exists in a single cell. That is, say I want to check for relationship of No. 19 (Cell K8) in cell C15 alone instead of the whole row (C15:G15, I15:M15). 

I have attached same file you provided.

Once this is done, then this project is over.

Thanks in anticipation of your assistance.

Warm regards,

John

I think you just need to amend the formula to:

=IF(ROW()<$T$2,"",COUNTIF(INDEX(RELATIONSHIP!$B$3:$J$92,OFFSET(INDIRECT('SALES BOOK'!$R$2),ROW()-'SALES BOOK'!$T$2,0),0),INDEX([1],$S$2+ROW()-$T$2))>0)

Hello Velouria,

As always, thanks for your quick response and interest in my project.

I tried tweaking the formula you have provided. I couldn't get my head around it. So what I did was to go back to the original formula in the file you provided and I was able to work around it with the SUMPRODUCT function by reducing the table range of SALES BOOK. This is working now.

Thanks so so much for all the help you have provided me.

You don't know how happy I am right now.

Cheers man.

I will test some more examples to know if everything is fine

Regards,

John