HOW DO U LOCK THE DATA



0
AS IN , IN VLOOKUP... TO KEEP THE CELL CONSTANT HW TO WE LOCK IT

1 Answer(s)


0

When using VLookUp or any other formula, you need to make the cell constant (absolute reference) by pressing the F4 key. This will keep the value in that cell as constant.