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
constants, then match with offset, and finally the whole thing. We want to
know which is the bit that's objecting to the error result
Nick
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
