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?