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?

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?

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?

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?

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?