Vlookup with upper and lower case lookup values

A

Angus

Hi,

I'm doing a vlookup with upper and lower case lookup
values so I may have an "a" referenceing one value and
an "A" referencing another. This is the code I am
using ... VLOOKUP(C318,[RateRecWithRepJul.xls]ReasonCode!
$A$6:$D$99,2,FALSE).

Do you know how I could get the vlookup to differentiate
between the two cases?


Thanks in advance,

Angus
 
B

Biff

Hi Angus!

Try this:

VLOOKUP(EXACT(C318),[RateRecWithRepJul.xls]ReasonCode!
$A$6:$D$99,2,FALSE)

Biff
 
A

Angus

Thanks Biff but it says I've entered too few arguments for
the formula

-----Original Message-----
Hi Angus!

Try this:

VLOOKUP(EXACT(C318),[RateRecWithRepJul.xls]ReasonCode!
$A$6:$D$99,2,FALSE)

Biff
-----Original Message-----
Hi,

I'm doing a vlookup with upper and lower case lookup
values so I may have an "a" referenceing one value and
an "A" referencing another. This is the code I am
using ... VLOOKUP(C318,[RateRecWithRepJul.xls]ReasonCode!
$A$6:$D$99,2,FALSE).

Do you know how I could get the vlookup to differentiate
between the two cases?


Thanks in advance,

Angus
.
.
 
B

Biff

Ooops! Disregard!
-----Original Message-----
Hi Angus!

Try this:

VLOOKUP(EXACT(C318),[RateRecWithRepJul.xls]ReasonCode!
$A$6:$D$99,2,FALSE)

Biff
-----Original Message-----
Hi,

I'm doing a vlookup with upper and lower case lookup
values so I may have an "a" referenceing one value and
an "A" referencing another. This is the code I am
using ... VLOOKUP(C318,[RateRecWithRepJul.xls]ReasonCode!
$A$6:$D$99,2,FALSE).

Do you know how I could get the vlookup to differentiate
between the two cases?


Thanks in advance,

Angus
.
.
 
B

Biff

Yeah, I goofed up on that one. sorry!

Try this:

=INDEX([RateRecWithRepJul.xls]ReasonCode!B$6:B$99,MATCH
(TRUE,EXACT(A1,[RateRecWithRepJul.xls]ReasonCode!
A$6:A$99)),0)

Entered as an array - CTRL,SHIFT,ENTER

Biff
-----Original Message-----
Thanks Biff but it says I've entered too few arguments for
the formula

-----Original Message-----
Hi Angus!

Try this:

VLOOKUP(EXACT(C318),[RateRecWithRepJul.xls]ReasonCode!
$A$6:$D$99,2,FALSE)

Biff
-----Original Message-----
Hi,

I'm doing a vlookup with upper and lower case lookup
values so I may have an "a" referenceing one value and
an "A" referencing another. This is the code I am
using ... VLOOKUP(C318,[RateRecWithRepJul.xls] ReasonCode!
$A$6:$D$99,2,FALSE).

Do you know how I could get the vlookup to differentiate
between the two cases?


Thanks in advance,

Angus
.
.
.
 

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

Top