Returning A Cell Value

  • On page 2 in cells C2:G2 I have a name like Joyce and I would like to have the name on page 1 in cell B2 without retyping the name. What formula would I use to do this.

  • Re: Returning A Cell Vaule


    I "assume" here (1) that the second page is a worksheet named Sheet2 and (2) that cells C2:G2 are merged:
    =Sheet2!C2
    If the cells you reference are not merged, it would be:
    =Sheet2!C2&Sheet2!D2&Sheet2!E2&Sheet2!F2&Sheet2!G2


    Quote from Ray_n_yellow

    On page 2 in cells C2:G2 I have a name like Joyce and I would like to have the name on page 1 in cell B2 without retyping the name. What formula would I use to do this.

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!