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?