Forum Discussion

Belle324's avatar
Belle324
Copper Contributor
Apr 16, 2020

Formula Help

Hello!

First time posting here. While I have used excel and love using it, I cannot figure out this formula/what the best route would be.

At this time, I want if one cell shows this text, fill in this range of cells with text in a different cell. For example, if cell BC3=“Regular”, all cells H through AN will fill with the text located in cell C.

I’m not sure if there is a way to even do this, but thought I would ask!
excel
Formulas and Functions

4 Replies

  • gyankosh's avatar
    gyankosh
    Brass Contributor
    Apr 16, 2020

    WHAT I UNDERSTOOD

    You want to set a formula after which if you change text in a particular cell, it should reflect in a big range.

    for this just apply the formula

    suppose the text you want to be copied is at C3 then it should be               =$c$3 in all the cells where you want to copy the text of c3. Now whatever you put in c3, it'll be copied to all the cells.

    it'll make the location absolute and you can copy it to as many cells as you want.

    you can refer here for more valuable information gyankosh.net/msexcel

    • Belle324's avatar
      Belle324
      Copper Contributor
      Apr 16, 2020
      Thank you for this explanation! However, I do not believe this will fit in the sheet I am working on. I apologize if I was unclear or am not understanding your explanation.

      Based on the photo provided, The information from cell BC, and below, can change based on what is inputted in a different sheet. For the current info in BC3, I would like G3 through AN3 to be filled with the info seen in cell C3. However, if the info in BC3 were to change to “Early,” I would like cells D3 through AK3 to be filled with the info seen in cell C3. Not quite sure how to do this and when I entered an IF formula that I thought would work, I received an error. Any further assistance or advice would be appreciated!

Resources