Originally Posted by Mazzaropi

Dear Pamanabh, Good Afternoon.

The reason about +1 is simple.

In this case the Function MATCH starts searching at column 2.

The Function VLOOKUP always starts numbering columns as column 1.
As the used formula is indexed, you need to add +1 to capture the right answer.

Try to remove the +1 and observe the answer.
It will be the same value of a previous column.

Is it OK?

Have a nice day.