I'm using the VLOOKUP function to find a specific value in a table and enter its corresponding value into a cell. The formula is below:

=VLOOKUP(Q2,HBF!A1:B72,2,FALSE)

This formula works fine for the first cell, but when I copy it into cells below it in my table, the cell references change. What I want the function to do is change the lookup_value (Q2) but leave the table array (HBF!A1:B72) the same. So I want the formula to look something like this:

=VLOOKUP(Q3,HBF!A1:B72,2,FALSE)
=VLOOKUP(Q4,HBF!A1:B72,2,FALSE)
=VLOOKUP(Q5,HBF!A1:B72,2,FALSE)
=VLOOKUP(Q6,HBF!A1:B72,2,FALSE)

Instead, I'm getting something like this:

=VLOOKUP(Q3,HBF!A2:B73,2,FALSE)
=VLOOKUP(Q4,HBF!A3:B74,2,FALSE)
=VLOOKUP(Q5,HBF!A4:B75,2,FALSE)
=VLOOKUP(Q6,HBF!A5:B76,2,FALSE)

Can anyone suggest how I might change the "lookup_value" depending on the cell, but keep the "table_array" field the same?

Thanks

-zack