Posted to microsoft.public.excel.programming

Troy[_2_]

external usenet poster

Posts: 18

copy Vlookup down

I'm copying this formual straight down.

=IF(ISNA((G6*(VLOOKUP(C6,A1:B1117,2,FALSE)))/3600),0,(G6*(VLOOKUP(C6,A1:B1117,2,FALSE)))/3600)

But when I do, is shifts where my bank or data is down. For example when I
copy to the next cell down it will be: A2:B1118.

How do I copy the formual multiple times without shifting the bank location?

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
vlookup copy down	Davidm	Excel Discussion (Misc queries)	1	February 15th 10 10:05 PM
vlookup copy down	Luke M	Excel Discussion (Misc queries)	0	February 15th 10 09:55 PM
Vlookup Copy Formula	Joe K.	Excel Worksheet Functions	2	November 19th 08 03:34 PM
PLEASE HELP - VLOOKUP COPY	I.C.E.	Excel Discussion (Misc queries)	3	October 11th 06 11:41 AM
copy formula, VLOOKUP	BRustigian[_2_]	Excel Programming	1	September 14th 04 06:30 AM

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

About Us

"It's about Microsoft Excel"

Menu

About Us