VLOOKUP copy problems

[Back2Basics]

I am using a VLOOKUP formula, but when I drag it down it doesn't keep the same array selection.

Is there a way so that I can drag it and it relates to the cell to the left, but the array selected stays the same. I don't really want to type the same thig out for every cell as there are 6000.

I am using: =VLOOKUP(D2,Working!A2:C23,2,FALSE)

and want D2 to change accordingly but for working!A2:C23 to stay the same

[vandanavai]

Hello
Try following

=VLOOKUP(D2,Working!$A$2:$C$23,2,FALSE)

[Back2Basics]

Awesome thanks very much Vanda