Too tricky for me MATCH(OFFSET(IF(INDIRECT("")

**SvenGolster** · 05-28-2014, 07:04 PM

If someone could help on this ...thnx..
There are hundreds of these forms. Sheet2.O2:V8 is the result of dragging the formulas down from O2:V2.
As you can see, O2:V2 is an "E" (From A3), O3:V3 is an "A" etc.
The letters in ColA are more or less random and I cannot change that so I need a formula that will look at every
5th row, match the letter, then get data from the various cells. That data is always gathered from the same locations
from the letter it matches in ColA. I.E. It is always in multiples of 5 rows and starts from A3. The parameters
(like for an OFFSET are then A3,-1,7(for H2):A3,-1,8(for I2):A3,-1,10(K2):and A3,0,10(K3) and so on.
Sheet1 shows the expected results. 1 formula altered for each Letter A-F would do it. If you need more info, ask away...thanks
columns are .5 and rows .13

**SvenGolster** · 05-29-2014, 01:33 PM

Got it thank you

**martindwilson** · 05-29-2014, 01:48 PM

this formula in O2 filled across and down gives the same results
=INDEX($H:$M,IF(CHOOSE(COLUMNS($A$1:A1),1,2,4,4,4,4,5,6)=4,COLUMNS($A$1:A1)+1+ROWS($A$1:A1)*5-7,ROWS($A$1:A1)*5-3),CHOOSE(COLUMNS($A$1:A1),1,2,4,4,4,4,5,6))

**SvenGolster** · 05-30-2014, 12:35 PM

OK, the key to this is getting the right datra from the right form. I cannot put
Data from a "C" form into an "A" pile....Column A on Sheet2 has letters that
identify a form's origins. The sections of columns on Sheet1 store data from
each of the forms from A2. Forms with Sheet2!A3="B" go into the "B" section
of Sheet1. A formula that works but doesn't increment and will stop after
reading 1 form is: =IF(Sheet2!A3="F",OFFSET(Sheet2!A3,-1,7)
If this could do the same as your suggestion and/or my formula with INDIRECT
then we'd have a "Go".