On Mon, 1 Dec 2014, Blake Watson wrote:
Got a formula with a pair of ranges:
=IFERROR(MATCH(TRUE,OFFSET(Sh1!$L$27,I20,0):'Sh1'!$L$38,0)+I20,false)
Can you try breaking that down into individual bits, to see where the
problem comes in? So try just the offset bit, then the match with
There seems to be two problems (testing this in Google Sheets): MATCH
doesn't like having the page expressed on the end part of the range. This
does not work:
=MATCH(TRUE,Sh1!$L$27:Sh1!$L$38,0)
But this does:
=MATCH(TRUE,Sh1!$L$27:$L$38,0)
Also, MATCH does not like having OFFSET specifying the
By all, I mean: Nick.
Reminding me that I could parse the formula in a debugger and examine the
results is what clued me in.
On Tue, Dec 2, 2014 at 1:59 PM, Blake Watson blake.wat...@pnmac.com wrote:
OK, false alarm. Everything's parsing fine. The problem was somewhere
else entirely.
OK, false alarm. Everything's parsing fine. The problem was somewhere else
entirely.
Thanks all for the help.