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 refers to a few cells. When I extend this formula row-wise or col-wise, i see that these cell reference get updated which is fine.

Now, I have one of the formulas which does a vlookup form a table in a diff sheet. Now, when i extend this formula, i want only the local cell reference to update but the reference to the table in the other sheet on which i do a vlookup should remain constant. Is it possible to do this?

share|improve this question

migrated from stackoverflow.com Oct 11 '11 at 7:29

This question came from our site for professional and enthusiast programmers.

3  
see cpearson.com/excel/relative.aspx for a detailed explanation of absolute and relative referencing – brettdj Oct 10 '11 at 11:10
up vote 1 down vote accepted

Append dollar sign ($) to target column/row numbers like A4 -> $A$4

share|improve this answer

Also, when you use formulas like vlookup that need ranges, you can (and generaly should) use Defined Names.

share|improve this answer

You must log in to answer this question.

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