PROVIDING ACCURATE, RELIABLE AND STRAIGHT TO THE POINT KNOWLEDGE ABOUT DIFFERENT IT TOOLS EXPLAINED WITH PRACTICAL EXAMPLES
VLOOKUP FOR A CASE SENSITIVE MATCH AND RETURN THE VALUE AGAINST THE FOUND MATCH AS PER REQUIREMENT
The function is very specifically meant for the situations such as:
The syntax of the GKVLOOKUP FORMULA is
=GKVLOOKUP(COMPLETE RANGE OF TABLE, VALUE TO BE MATCHED, COLUMN TO BE RETURNED )
Let us take the example of a coded language with the following codes.
We need to find out the corresponding numbers for the given codes from the given table.
CODES | NUMBER EQUIVALENT |
A | 1 |
a | 1.5 |
B | 2 |
b | 2.5 |
C | 3 |
c | 3.5 |
D | 4 |
d | 4.5 |
Ab | 3.5 |
AB | 3 |
cb | 6 |
Cb | 5.5 |
de | 9.5 |
From the given table, find out the code for Ab,AB,Cb,cb and c
VLOOKUP will fail in this case as it’ll always return the first instance even if the case is different but letters are same. Let us see how GKVLOOKUP performs here.
Let us find out the numbers for the given codes.
OTHER WAYS TO REACH THIS ARTICLE
YOU MAY LIKE