Posted to microsoft.public.excel.misc

[email protected] djohns158@gmail.com is offline

external usenet poster

Posts: 29

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

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
copying vlookup	jane	Excel Worksheet Functions	3	October 28th 07 04:33 AM
copying the Hyperlink function result without copying the actual formula	mcheng	Excel Worksheet Functions	2	June 9th 07 02:43 AM
copying VLOOKUP w/o changing formula	rldjda	Excel Worksheet Functions	2	February 7th 07 02:07 AM
Copying VLOOKUP	I.C.E.	Excel Discussion (Misc queries)	6	October 11th 06 09:30 AM
copying VLOOKUP	Jane	Excel Worksheet Functions	5	January 26th 06 02:08 AM

All times are GMT +1. The time now is 08:23 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us