copy Vlookup down

T

Troy

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

StumpedAgain

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)
 
T

Troy

your're the man

StumpedAgain said:
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)
Click to expand...
 
G

Gord Dibben

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Vlook up to combine data in many sheets 1
Continued issues 2
VLookup error - Sub or function not defined 4
VBA userform Vlookup Excel 1
vlookup working in one instance, but not another 3
Vlookup for value 1
Trying to use Vlookup but it wont work 1
Macro to create seperate lists 1

Top