Question

This question was asked in Use of Hlookup
ARIHANT YAMAHA's image

I am using lock only selected columns in excel sheet , no other columns or rows .

please guide me about my question..?