1. Select the cell with the vlookup formula that you want to copy.
2. Click on the cell reference in the "table_array" part of the formula (the part that specifies the range of cells to search for the lookup value).
3. Press the F4 key on your keyboard. This will add dollar signs ($) to the cell reference, making it an absolute reference. For example, if the original formula had "A1:B10" as the table array, it will now have "$A$1:$B$10".
4. Copy the formula by pressing Ctrl+C or right-clicking and selecting "Copy".
5. Select the range of cells where you want to paste the formula.
6. Paste the formula by pressing Ctrl+V or right-clicking and selecting "Paste".
7. Excel will automatically adjust the "lookup_value" part of the formula to match the row number of each cell in the range you pasted to, but the "table_array" part will remain the same.

By using absolute cell references, you can copy the formula to multiple cells without worrying about the "table_array" part of the formula changing.