Super User is a question and answer site for computer enthusiasts and power users. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I have a formula in Excel that looks like this:

=VLOOKUP(posts!C12,users!A2:B1800,2)

I would like to duplicate this formula down the whole column, however, I would like C12 to increment (C13, C14, C15 etc), but for the rest of the formula to stay the same.

So far, I have tried duplicating it manually onto the next 4 or 5 cells, then selecting those and double clicking the bottom right hand corner of the selection, however this doesn't work, almost, but not quite.

share|improve this question

Add a dollar sign $ before each coordinate that you want to be fixed. I.e., if you want C12 to turn into C13, do $C12 and the C will be fixed but the 12 will increment. IF you want both values to be fixed, use $C$12.

share|improve this answer
    
worked a treat. thankyou kindly. – Tisch Sep 5 '10 at 21:33
    
another neat way to do this is to click on the range you want to change and press F4 until the $s are as you like them. Also I would be careful that your lookup range stays static users!$A$2:$B$1800 – datatoo Sep 8 '10 at 16:51

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .