See all How-To Articles

Formula to Copy Value to Another Cell in Excel & Google Sheets

This tutorial demonstrates how to create a formula to copy a value to another cell in Excel and Google Sheets.

 

copycell intro

Create Formula to Copy Value

  1. Click in the cell where you wish the formula to be created.
  2. Press the = (equal) key on the keyboard, and then click on the cell that contains the value you need.

 

copycell formula

 

The formula is built for you using a cell reference.

=D3
  1. Press the ENTER key on the keyboard. (1) Your formula appears in the formula bar while (2) the value appears in the actual cell.

 

copycell formula result

 

  1. Change the value in the original cell (e.g., D3) to update the value in the formula.

 

copycell updatevalue

 

Functions to Return Cell Values

You can also return a value from one cell to another cell by using Excel functions.

The VLOOKUP Function, for example, allows you to look up values in one area of the worksheet, and return the value to another area of the worksheet.

 

copycell vlookup

 

You can also use HLOOKUP to return a similar result.

 

copycell hlookup

 

Alternatively, you can use the INDEX and MATCH Functions, depending on how the data is set up.

 

copycell index match

 

Copy to Another Cell With VBA

You can also use VBA to copy the values using a formula to another cell.

1. In the VBE, create a module within your workbook, and then create the following macro.

Sub CopyValueWithFormula()
   Range("G3") = "=D3"
End Sub

2. Switch back to Excel, and then, in the Ribbon, select Developer  > Code > Macros.

copyformulas ribbon macro

3. Select the macro you created and then click Run.

copyformulas macro run

4. G3 will then be populated with the Formula below:

=D3

copyformulas macro formula

Formula to Copy Value in Google Sheets

Google Sheets works in exactly the same way as Excel when copying a cell value using a formula.

 

copycell gs intro

See all How-To Articles