paste VLOOKUP formula

[1stNoobie]

Hello,


I am using the following formula<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o></o>
=IF(C8=0,"",VLOOKUP(C8,F9:G28,2,0))<o></o>
When I copy the formula down to the next row the table array is changing as well as the rest of my values. <o></o>
So the next row will look like this
=IF(C9=0,"",VLOOKUP(C9,F10:G29,2,0))<o></o>
But it should actually look like this<o></o>
=IF(C9=0,"",VLOOKUP(C9,F9:G28,2,0))<o></o>
Am I copying my formula wrong or what do I need to do to paste it without my table array changing?<o></o>

 

[Legacy 68668]

change to absolute reference

$F$9:$G$28

 

[1stNoobie]

Thanks! That was a super fast reply greatly appreciated.

 

[swst]

1stNoobie

Your range needs to be referenced

In your formula click on F9 then hit the function key F4
Do the same for G28

This will fix the range thats being looked up
Then copy the formula down

Steve

 

[pnafissi]

change to absolute reference

$F$9:$G$28

I have tried both the range name and absolute ref but copy and paste still messes up the Vlookup. Here's my Vlookup formulas that I have tried:
=VLOOKUP(F3,ClockIn,2,FALSE)*Definitions!$B$5+VLOOKUP(G3,Organizing,2,FALSE)*Definitions!$F$5+VLOOKUP(H3,Reporting,2,FALSE)*Definitions!$J$5+VLOOKUP(E3,Misconduct,2,FALSE)*Definitions!$N$5
=VLOOKUP(F3,Definitions!$A$6:$B$10,2,FALSE)*Definitions!$B$5+VLOOKUP(G3,Definitions!$E$6:$F$10,2,FALSE)*Definitions!$F$5+VLOOKUP(H3,Definitions!$I$6:$J$10,2,FALSE)*Definitions!$J$5+VLOOKUP(E3,Definitions!$M$6:$N$10,2,FALSE)*Definitions!$N$5