From the above figure, it is amply clear why the INDEX+MATCH combination of functions is much better than the VLOOKUP Function. For two reasons (a) it does not require that the worksheet data be sorted, only that the value being sought is unique, and (b) a reverse direction lookup is also possibe, as shown in the figure, where the Employee number is looked up using the name of the employee. Cheers !!
CA Vikram Shankar Mathur
12-Apr-2017 | 01:39 Hours IST