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?

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?

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?

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?

Or give the table range a name.

Select A1:B1117 and Insert>Name>Define

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 <(E-Mail Removed)> 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?