0

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?

1

2 Answers 2

1

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

1

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

You must log in to answer this question.

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