Quote:
Originally Posted by Pamanabh
Hi Good evening !!!!!!
Yes its working !!!! thanks !!!!
got entire formula just want know the logic behind passing Argument +1,o
|
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.