I'm not sure why you're getting #N/A. Or are you actually getting a
#NUM! error?

In article ,
"sac73" wrote:

Actually the range is quite a bit bigger. It's from H4:K57, but with the
offset formula from Biff, it covers W4:W263. (H1:K3 are not used, and there
is a break from H16:K17)

I have tried your suggestion, but I am getting a #N/A in cell Y2. What am I
doing wrong?