How do i lock down the values when using VLOOKUP Function?



0
How do i lock down the values when using VLOOKUP Function?

2 Answer(s)


0

Go to the respective cell. Inside the cell lets say there is "A2" that you want to lock. Place the cursor inbetween A and 2 and press F4. It should lock A2 then.

0

Select the Shell (row or columns) you want to Free or lock. ctrl+c (copy the line)right click there on the same columns --> Paste Specials --> Paste velue only.

Your Answer

Click on this code-snippet-icon icon to add code snippet.

Upload Files (Maximum image file size - 1.5 MB, other file size - 10 MB, total size - not more than 50 MB)

Email
Password