Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

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 Oct 11 '11 at 7:29

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

see 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

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.