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 starting part of the range. So, this (removing the sheet specification): =(MATCH(TRUE,OFFSET($L$27,I20,0):$L$38,0)) Does not work. Neither does SUM: =SUM(OFFSET($L$27,I20,0):$L$38,0) Suggesting the problem is using OFFSET. The user's goal (in case there's a better way to express it) starting from this: Reason1 True Reason2 False Reason3 False Reason4 True Reason5 True Is to populate a different list like so: Reason1 Reason4 Reason5 In other words, the TRUEs from the reason list create a new list of only applicable reasons, with no gaps. On Tue, Dec 2, 2014 at 7:11 AM, Nick Burch <apa...@gagravarr.org> wrote: > 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: user-unsubscr...@poi.apache.org > For additional commands, e-mail: user-h...@poi.apache.org > > -- *Blake Watson* *PNMAC* Application Development Manager 5898 Condor Drive Moorpark, CA 93021 (805) 330.4911 x7742 blake.wat...@pnmac.com <melanie.petros...@pnmac.com> www.PennyMacUSA.com <http://www.pennymacusa.com/>
