Differentiating Case Sensitivity in a Vlookup

C

Cadders

Hi,

Is there any way that a vlookup can work correctly against a case sensitive
list please?

for example, I have a list and range like this:

list range
a 1
A 2
b 3
B 4

I am wanting to pull through the correct number in the range depending on
whether it is upper or lower case?

Thanks in advance
 
M

Mike H

Hi,

One way with your lookup value in C1

=SUMPRODUCT(--(EXACT(C1,A1:A4)),B1:B4)

Mike
 
D

Domenic

Assuming that A2:B5 contains the lookup table, and D2 contains the
lookup value, try the following formula that needs to be confirmed with
CONTROL+SHIFT+ENTER...

=INDEX(B2:B5,MATCH(TRUE,EXACT(A2:A5,D2),0))
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Distinguishing between upper & lower case characters for vlookup ..... 3
Vlookup student grades 7
Banging head against wall with VLOOKUP 4
Case-sensitive sort problem 1
List vector using upper and lower limits 6
Case-sensitivity in a stored procedure 6
vLookup formula 1
Vlookup in VBA (how to use a dynamic range) 2

Top