Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
copy Vlookup down
Some dollar signs should do the trick:
=IF(ISNA((G6*(VLOOKUP(C6,$A$1:$B$1117,2,FALSE)))/3600),0,(G6*(VLOOKUP(C6,$A$1:$B$1117,2,FALSE)))/3600) -- -SA "Troy" wrote: 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? |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
copy Vlookup down
you're the man
"Troy" wrote: 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? |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
copy Vlookup down
your're the man
"StumpedAgain" wrote: Some dollar signs should do the trick: =IF(ISNA((G6*(VLOOKUP(C6,$A$1:$B$1117,2,FALSE)))/3600),0,(G6*(VLOOKUP(C6,$A$1:$B$1117,2,FALSE)))/3600) -- -SA "Troy" wrote: 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? |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
copy Vlookup down
Or give the table range a name.
Select A1:B1117 and InsertNameDefine Name it mytable Substitute the A1:B1117 with mytable =IF(ISNA((G6*(VLOOKUP(C6,mytable,2,FALSE)))/3600),0,(G6*(VLOOKUP(C6,mytable,2,FALSE)))/3600) Gord Dibben MS Excel MVP On Thu, 10 Jul 2008 13:43:00 -0700, Troy wrote: your're the man "StumpedAgain" wrote: Some dollar signs should do the trick: =IF(ISNA((G6*(VLOOKUP(C6,$A$1:$B$1117,2,FALSE)))/3600),0,(G6*(VLOOKUP(C6,$A$1:$B$1117,2,FALSE)))/3600) -- -SA "Troy" wrote: 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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
vlookup copy down | Excel Discussion (Misc queries) | |||
vlookup copy down | Excel Discussion (Misc queries) | |||
Vlookup Copy Formula | Excel Worksheet Functions | |||
PLEASE HELP - VLOOKUP COPY | Excel Discussion (Misc queries) | |||
copy formula, VLOOKUP | Excel Programming |