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
Patrick2788's avatar
Patrick2788
Silver Contributor
Mar 13, 2023
This is potentially very simple depending on what else is in the sheet near the target cells. Are you able to share an anonymized sample of the arrangement?
  • 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.

Resources