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?
|