Vlookup formula query

[Ecel Dumbo]

Hi, please see this formula

VLOOKUP($C64,'Actual Sales'!$B$162:$K$186,2,0)

i would like to know if it is possible to get the referencing column "2" in the formula automatically changed to "3" as i drag the formula sideways

right now, i am manually changing the "2" in the formula to "3", "4" , 5" etc as I copy the formula sideways​

 

[Hui]

Ecel Dumbo,
I'll assume you are using this in a Cell in Column E
Change the formula to: VLOOKUP($C64,'Actual Sales'!$B$162:$K$186,Columns($D$1:E$1),0)
now as you copy it across it will adjust

 

[Ecel Dumbo]

thanks HUI. appreciate your help.