42. VLOOKUP from Right to Left
VLOOKUP always looks up from Left to Right. Hence, in the below table, I can find Date of
Birth of Naomi by giving following formula –
=VLOOKUP("Naomi",B:D,3,0)
But, If I have to find Emp ID corresponding to Naomi, I can not do it through VLOOKUP
formula. To perform VLOOKUP from Right to Left, you will have to use INDEX / MATCH
combination. Hence, you will have to use following formula –
=INDEX(A:A,MATCH("Naomi",B:B,0))
43. Case Sensitive VLOOKUP
Suppose your have data like below table and you want to do a case sensitive VLOOKUP
If perform a regular VLOOKUP on SARA, I would get the answer 4300. But in a case sensitive
VLOOKUP, answer should be 3200. You may use below formula for Case Sensitive VLOOKUP
