| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to copy a vlookup formula without changing the "table_array" p | Excel Worksheet Functions | |||
| range of Formula copy but not changing the content | Excel Discussion (Misc queries) | |||
| How to copy range without changing formulas? | Excel Discussion (Misc queries) | |||
| Copy formula into multiple cells without changing range | Excel Worksheet Functions | |||
| changing data in range of vlookup | Excel Discussion (Misc queries) | |||
Linear Mode
