# Repeat Cell Value N times in Excel

This post will guide you how to repeat cell value N times in Excel. How do I copy cell value N times in Excel.

## Repeat Cell Value N times

Assuming that you have a list of data that contain two column and one column is cell value that you want to repeat, and another column contain N number. To repeat cell value N times in Excel, just do the following steps:

#1 Insert a column to the left of A, so your current A and B columns are now B and C. #2 Put 1 in A1 #3 Put =A1+C1 in A2 and drag the AutoFill Handle down to Cell A5. #4 Put an empty string in B5, by just entering a single quote (‘) in the cell #5 Put a number 1 in E1, a number 2 in E2, and copy down as to get 1, 2, …, 14 #6 Type the following formula based on the VLOOKUP function into the formula box of cell F1 and then drag the AutoFill Handle over other cells to apply this formula.

`=VLOOKUP(E1,\$A\$1:\$B\$5,2)` ### Related Functions

• Excel VLOOKUP function
The Excel VLOOKUP function lookup a value in the first column of the table and return the value in the same row based on index_num position.The syntax of the VLOOKUP function is as below:= VLOOKUP (lookup_value, table_array, column_index_num,[range_lookup])….

Sidebar 