Thank you. I already got the results to show from your formula in post #17. Basically my question is, lets say the formula checks the first range W19:AC19, taking the 1st column J for example, the value in J14 is 12, so will the formula find number 13 in B3? The reason I am asking is because the blue range in the B column reaches only up to row 10 and number 13 is found in row3.

That's why I was trying to extend all ranges in B:H before and I was getting the ref# error.

Thank you