Forum Discussion

Rick_Lehnen's avatar
Rick_Lehnen
Copper Contributor
Mar 13, 2023

Pulling info consistently from two cells right of original target

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 ...
excel
Rick_Lehnen's avatar
Rick_Lehnen
Copper Contributor
Mar 13, 2023

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......

 

Patrick2788's avatar
Patrick2788
Silver Contributor
Mar 13, 2023

Rick_Lehnen 

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)))

 

  • Rick_Lehnen's avatar
    Rick_Lehnen
    Copper Contributor
    Mar 13, 2023
    And you lost me again. I truly do want to understand.
    • Patrick2788's avatar
      Patrick2788
      Silver Contributor
      Mar 13, 2023

      Rick_Lehnen 

      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?

Resources