Auto populating cells below with vlookup

[Trojnfn]

I don't know if this has been asked before but I do not have time to search all the threads for the topic. I have sheet1 that contains numerous cities and sheet2 that contains unique city names and zip codes. I used vlookup to search sheet2 to find the zip codes and populate sheet 1. My formula is =VLOOKUP(A2,Sheet2!A2:C142,3,FALSE). This works fine and I am able to populate the first row (acutally the second row because the first row contains the header). I then put the cursor at the bottom right corner to get the plus sign and click to try and autopulate all the other cells with this formula. What is happening is that all subsequent cells populate at #N/A because the formula increases the cell numbers by one. For example, the formula for the next cell becomes =VLOOKUP(A3,Sheet2!A3:C142,3,FALSE) and it should be
=VLOOKUP(A3,Sheet2!A2:C142,3,FALSE) because A2:C142 is the array from Sheet2, not A3:C142. The lookup column
A2, A3, etc. increases by one is correct but how do I prevent the array from increasing by one? It should always be
A2:C142, not A3:C142, A4:C142, etc...

[daffodil11]

Without applying "$" to your column and row references, they will adjust as the cell containing them moves. This is called relative referencing.

To make your reference absolute, place a $ sign in front of each row and column.

=VLOOKUP(A2,Sheet2!$A$2:$C$142,3,FALSE)

Alternatively, you can highlight the range in your formula: Sheet2!A2:C142 and hit F4

[Trojnfn]

Thanks daffodil11. Your suggestion with the $ worked perfectly. Prolbem sovled. I added to your reputation. Thanks again.

[daffodil11]

No problem.