how to lock down the formula in vlookup concept?

2 Answer(s)


just use f2 funtion key

In the table array of VLookup function,press the 'F4' key which is used as short-cut key for absolute reference.