Forum Discussion

Mitchyll2280's avatar
Mitchyll2280
Copper Contributor
Nov 03, 2022
Solved

Duplicating cell value on another sheet

Hello,   I am pretty new to excel and this community. I have some knowledge of doing formulas, but all pretty basic. So, what I would like to do is this: If the value of cell "i2" in "sheet2" is g...
  • OliverScheurich's avatar
    OliverScheurich
    Nov 04, 2022

    Mitchyll2280 

    You are welcome. After the formulas are entered in cells A14 and K14 you can drag them down. The results are then displayed in ranges A14:A29 and K14:K29 for example as shown in the attached screenshot and file.

     

Resources