Draging formulas and table relativity

hello

I am using a lookup formula:

=VLOOKUP(B6,'Issue Key'!A1:B45,2)

When I drag the cell to replicate the formula, the B6 updates relative to the row, which is as expected.

The problem is that the lookup area A1:B45 also changed relative to how many rows down the formula has been copied to.

Is there anyway of preventing this as the lookup area remains constant?

Thank you.

You can use a dollar-sign to prevent this. So your =VLOOKUP(B6,'Issue Key'!A1:B45,2) should be =VLOOKUP(B6,'Issue Key'!$A$1:$B$45,2).

In the Excel Help it says the following:
Absolute references If you don't want Excel to adjust references when you copy a formula to a different cell, use an absolute reference. For example, if your formula multiplies cell A5 with cell C1 (=A5*C1) and you copy the formula to another cell, Excel will adjust both references. You can create an absolute reference to cell C1 by placing a dollar sign ($) before the parts of the reference that do not change. To create an absolute reference to cell C1, for example, add dollar signs to the formula as follows:

=A5*$C$1

Switching between relative and absolute references If you created a formula and want to change relative references to absolute (and vice versa), select the cell that contains the formula. In the formula bar, select the reference you want to change and then press F4. Each time you press F4, Excel toggles through the combinations: absolute column and absolute row (for example, $C$1); relative column and absolute row (C$1); absolute column and relative row ($C1); and relative column and relative row (C1). For example, if you select the address $A$1 in a formula and press F4, the reference becomes A$1. Press F4 again and the reference becomes $A1, and so on.

I am really getting into this scripting!

Thank you very much for your input and help.