VLOOKUP lookup_array disaster!

[6two6rob]

I've been using VLOOKUP to show records from one sheet on another based on First Name and Last Name.

So far I've learned that VLOOKUP's lookup_value can use more than one cell by separating cell values with &" "&. So essentially I can put A2&" "&B2 to use VLOOKUP according to a person's first and last name.

As I drag the formula down to copy it using the box that highlights the cell, it changes the VLOOKUP lookup_value according to what row I'm on. So A2&" "&B2 becomes A3&" "&B3, A4&" "&B4 and so on...

Now here's the problem:

When I drag the box down with the formula inside of it to copy it down the rest of the table, the formula changes the number under lookup_array as well, which I don't want it to do. I ALWAYS want the lookup_array to stay the same, have the whole sheet selected.

How can this be done?

 

[AhoyNC]

You just need to lock the cells in your lookup array. To do this just put a $ in front of the column and row reference.
Say your lookup array is in the range D2 to G40. To lock it just use $D$2:$G$40.