| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
vlookup formula not copying
I manually put the vlookup formula into one row of my worksheet. It's
working fine. When I try to drag the formula down to the other rows, it copies everything except the range lookup. It just puts #ref where the range should be. That has never happened to me before. Is there something I'm doing wrong? I'm using Excel 2007. Any help would be appreciated. Thanks, Daryl |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
vlookup formula not copying
Post your formula.
-- wrote in message ... I manually put the vlookup formula into one row of my worksheet. It's working fine. When I try to drag the formula down to the other rows, it copies everything except the range lookup. It just puts #ref where the range should be. That has never happened to me before. Is there something I'm doing wrong? I'm using Excel 2007. Any help would be appreciated. Thanks, Daryl |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
vlookup formula not copying
On Feb 26, 1:17*pm, "PCLIVE" wrote:
Post your formula. -- wrote in message ... I manually put the vlookup formula into one row of my worksheet. *It's working fine. *When I try to drag the formula down to the other rows, it copies everything except the range lookup. *It just puts #ref where the range should be. *That has never happened to me before. *Is there something I'm doing wrong? *I'm using Excel 2007. *Any help would be appreciated. *Thanks, Daryl- Hide quoted text - - Show quoted text - =VLOOKUP(B6,'Vdr#'!1:1048576,2,FALSE) |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
vlookup formula not copying
On Feb 26, 1:17*pm, "PCLIVE" wrote:
Post your formula. -- wrote in message ... I manually put the vlookup formula into one row of my worksheet. *It's working fine. *When I try to drag the formula down to the other rows, it copies everything except the range lookup. *It just puts #ref where the range should be. *That has never happened to me before. *Is there something I'm doing wrong? *I'm using Excel 2007. *Any help would be appreciated. *Thanks, Daryl- Hide quoted text - - Show quoted text - =VLOOKUP(B8,'Vdr#'!#REF!,2,FALSE) This is what happens the formula becomes when I drag it down to lower cells. |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
vlookup formula not copying
Yes, it will return #REF! as =VLOOKUP(B6,'Vdr#'!1:1048576,2,FALSE)
copied down one row becomes =VLOOKUP(B6,'Vdr#'!2:1048577,2,FALSE) 1048577 is a non-existant row Using 1:1048576 tells Excel you are using every row in the spreadsheet and every column, thus 1048576 rows * 16,384 columns = 17,179,869,184 cells Just how big is your lookup table? Tyro wrote in message ... On Feb 26, 1:17 pm, "PCLIVE" wrote: Post your formula. -- wrote in message ... I manually put the vlookup formula into one row of my worksheet. It's working fine. When I try to drag the formula down to the other rows, it copies everything except the range lookup. It just puts #ref where the range should be. That has never happened to me before. Is there something I'm doing wrong? I'm using Excel 2007. Any help would be appreciated. Thanks, Daryl- Hide quoted text - - Show quoted text - =VLOOKUP(B8,'Vdr#'!#REF!,2,FALSE) This is what happens the formula becomes when I drag it down to lower cells. |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
vlookup formula not copying
On Feb 26, 2:00*pm, "Tyro" wrote:
Yes, it will return #REF! as =VLOOKUP(B6,'Vdr#'!1:1048576,2,FALSE) copied down one row becomes =VLOOKUP(B6,'Vdr#'!2:1048577,2,FALSE) *1048577 is a non-existant row Using 1:1048576 tells Excel you are using every row in the spreadsheet and every column, thus 1048576 rows * 16,384 columns = 17,179,869,184 cells Just how big is your lookup table? Tyro wrote in message ... On Feb 26, 1:17 pm, "PCLIVE" wrote: Post your formula. -- wrote in message ... I manually put the vlookup formula into one row of my worksheet. It's working fine. When I try to drag the formula down to the other rows, it copies everything except the range lookup. It just puts #ref where the range should be. That has never happened to me before. Is there something I'm doing wrong? I'm using Excel 2007. Any help would be appreciated. Thanks, Daryl- Hide quoted text - - Show quoted text - =VLOOKUP(B8,'Vdr#'!#REF!,2,FALSE) *This is what happens the formula becomes when I drag it down to lower cells.- Hide quoted text - - Show quoted text - My lookup table is 1000 rows and expected to grow. |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
vlookup formula not copying
1000 rows using all 16384 columns in each row?
Tyro wrote in message ... On Feb 26, 2:00 pm, "Tyro" wrote: Yes, it will return #REF! as =VLOOKUP(B6,'Vdr#'!1:1048576,2,FALSE) copied down one row becomes =VLOOKUP(B6,'Vdr#'!2:1048577,2,FALSE) 1048577 is a non-existant row Using 1:1048576 tells Excel you are using every row in the spreadsheet and every column, thus 1048576 rows * 16,384 columns = 17,179,869,184 cells Just how big is your lookup table? Tyro wrote in message ... On Feb 26, 1:17 pm, "PCLIVE" wrote: Post your formula. -- wrote in message ... I manually put the vlookup formula into one row of my worksheet. It's working fine. When I try to drag the formula down to the other rows, it copies everything except the range lookup. It just puts #ref where the range should be. That has never happened to me before. Is there something I'm doing wrong? I'm using Excel 2007. Any help would be appreciated. Thanks, Daryl- Hide quoted text - - Show quoted text - =VLOOKUP(B8,'Vdr#'!#REF!,2,FALSE) This is what happens the formula becomes when I drag it down to lower cells.- Hide quoted text - - Show quoted text - My lookup table is 1000 rows and expected to grow. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| copying vlookup | Excel Worksheet Functions | |||
| copying the Hyperlink function result without copying the actual formula | Excel Worksheet Functions | |||
| copying VLOOKUP w/o changing formula | Excel Worksheet Functions | |||
| Copying VLOOKUP | Excel Discussion (Misc queries) | |||
| copying VLOOKUP | Excel Worksheet Functions | |||
Hybrid Mode
