Mar 13 2023 10:57 AM
Thanks for helping. I Have one cell (S4) where I am using ‘=C1’ to extract info. I would like to pull info from E1 (two cells to the right) and place in S5. Further down, I want to use ‘=C5’ in cell S6 and automatically pull info from E5 to place in S7. The draw will always be from the second cell to the right of the first one. This will be movement between sheets. Any ideas?
Second possible question: Can I ask it to look up the number in S4 on sheet 2, using only column C on sheet one, then pull the info from two columns to the right of that cell (E on sheet one) and place in S5 on sheet 2? Thanks.
Mar 13 2023 11:40 AM
Mar 13 2023 11:51 AM
=IF(ISEVEN(ROW()),INDEX(C:C,ROW($C$2)*(ROW(C1)-ROW($C$1))+1),INDEX(E:E,ROW($C$2)*(ROW(C1)-ROW($C$1))-1))
Does this return the expected result?
Mar 13 2023 12:47 PM
@Patrick2788 Actuals:
Here we go.....Start at 'Handout" D8. Notice C8. Find 670306 in Column B on 'Pricing' (it's in B90). Pull info from C90 and place on 'Handout' at D8. It will make my life simpler......
Mar 13 2023 01:18 PM
Mar 13 2023 02:27 PM
This is the idea:
data is a dynamic range
=LET(c,WRAPROWS(TAKE(data,,1),4),e,WRAPROWS(TAKE(data,,1),4),VSTACK(TAKE(c,,1),TAKE(e,,1)))
Mar 13 2023 03:17 PM
Mar 13 2023 03:30 PM
Does it show the expected result when you open the attached file? If there isn't an entry in cell C1 then the formula returns 0 in cell S4. If E1 is empty the formula returns 0 in cell S5.
Mar 13 2023 03:59 PM
Here is what the formula is doing:
If you're getting an error in your workbook, you'll have to provide some details. Did you open the workbook?