Reply to thread

Message: [QUOTE="Mazzaropi, post: 7401915"] 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 righ 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 +------------------------------------------------------------------- +------------------------------------------------------------------- [/QUOTE]