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

V

VickyL872

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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Edit links - in Vlookup 1
How do I insert a dynamic reference of a range inside VLOOKUP? 4
Excel Help to copy information from one row at a time to another sheet 1
Referring to a cell by using another cell for the row number 6
a data validation list that contains a list of named ranges - not alist from a named range 1
How do I reference a "range" for a specific table_array in VLOOKUP 3
vlookup---using data outside the range specified in the formula 4
Column reference in Vlookup formula 1

Top