VLOOKUP range changes using autofill

[drewber]

This is probably just a noob issue that I'm overlooking or unfamiliar with.

My data set is entering a name in one column (ie, C2) and VLOOKUP fills in the Supervisor name by looking in another tab (Staff) for tech and corresponding supervisor.

So when I use the pull down autofill (I dont know the official name - the green button by the red arrow above), it changes the row/columns for both lookup and table array. See below.

I need the table array to keep the same original range Staff!A2:B10, but lookup value to change when using the "autofill". I have tried using $ to lock, but it didn't seem to work.
Thanks in advance

 

[Fluff]

You need to lock the rows like Staff!A$2:B$10

 

[drewber]

You need to lock the rows like Staff!A$2:B$10

Thank you. I had put the $ in the wrong place. I knew it was something simple

 

[Fluff]

You're welcome & thanks for the feedback.