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?

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

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


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


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

Your Answer

By clicking "Post Your Answer", you acknowledge that you have read our updated terms of service, privacy policy and cookie policy, and that your continued use of the website is subject to these policies.

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