How do I copy a vlookup formula without changing the data range?
 

I am trying to copy a vlookup formulat from one row to another row. However,
the data range of the formula changes. My original data range is A1:O5049,
the data range in the formula on row 500 is A499:V5548. This is creating my
vlookup from capturing all data from the spreadsheet it is pulling from. How
do I keep the data range the same?

How do I copy a vlookup formula without changing the data range?
 

$A$1:$O$5049

"VickyL872" wrote:

I am trying to copy a vlookup formulat from one row to another row. However,
the data range of the formula changes. My original data range is A1:O5049,
the data range in the formula on row 500 is A499:V5548. This is creating my
vlookup from capturing all data from the spreadsheet it is pulling from. How
do I keep the data range the same?

How do I copy a vlookup formula without changing the data range?
 

Dennis wrote:
$A$1:$O$5049

"VickyL872" wrote:


I am trying to copy a vlookup formulat from one row to another row. However,
the data range of the formula changes. My original data range is A1:O5049,
the data range in the formula on row 500 is A499:V5548. This is creating my
vlookup from capturing all data from the spreadsheet it is pulling from. How
do I keep the data range the same?

Give the daata range a name.

Alan Beban