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?