VLookup & Case Sensitivity

[KHogwood-Thompson]

Hi All,

I am trying to compare two spreadsheets of text strings, I only want to find
those that match content and case. Currently Excel says that they match even
if the case is not matching ie

Follow Up is not the same as Follow up

But with my current standard vlookup statement, Excel returns these values
as matching.

Please can someone help.

Thanks
--
K Hogwood-Thompson

[starguy]

try this

=IF(EXACT(K4,VLOOKUP(K4,I5:J11,1,FALSE)),VLOOKUP(K4,I5:J11,2,FALSE))

change references accordingly.

Hi All,

I am trying to compare two spreadsheets of text strings, I only want to find
those that match content and case. Currently Excel says that they match even
if the case is not matching ie

Follow Up is not the same as Follow up

But with my current standard vlookup statement, Excel returns these values
as matching.

Please can someone help.

Thanks
--
K Hogwood-Thompson

[Max]

One way ..

Assume you're using this in B1, with B1 copied down:
=VLOOKUP(A1,$E$1:$F$10,2,0)

Try placing this instead in B1, then array-enter the formula by pressing
CTRL+SHIFT+ENTER, instead of just pressing ENTER:
=IF(A1="","",INDEX($F$1:$F$10,MATCH(TRUE,ISNUMBER(FIND(A1,$E$1:$E$10)),0)))
Copy B1 down

Adapt the ranges to suit ..
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"KHogwood-Thompson" wrote:
> Hi All,
>
> I am trying to compare two spreadsheets of text strings, I only want to find
> those that match content and case. Currently Excel says that they match even
> if the case is not matching ie
>
> Follow Up is not the same as Follow up
>
> But with my current standard vlookup statement, Excel returns these values
> as matching.
>
> Please can someone help.
>
> Thanks
> --
> K Hogwood-Thompson

[Dave Peterson]

One more...

=INDEX(Sheet2!B1:B999,MATCH(TRUE,EXACT(A1,Sheet2!A1:A999),0))

This is an array formula. Hit ctrl-shift-enter instead of enter. If you do it
correctly, excel will wrap curly brackets {} around your formula. (don't type
them yourself.)

Adjust the range to match--but you can't use the whole column.

KHogwood-Thompson wrote:
>
> Hi All,
>
> I am trying to compare two spreadsheets of text strings, I only want to find
> those that match content and case. Currently Excel says that they match even
> if the case is not matching ie
>
> Follow Up is not the same as Follow up
>
> But with my current standard vlookup statement, Excel returns these values
> as matching.
>
> Please can someone help.
>
> Thanks
> --
> K Hogwood-Thompson

--

Dave Peterson

[KHogwood-Thompson]

thanks, worked perfectly!
--
K Hogwood-Thompson


"starguy" wrote:

>
> try this
>
> =IF(EXACT(K4,VLOOKUP(K4,I5:J11,1,FALSE)),VLOOKUP(K4,I5:J11,2,FALSE))
>
> change references accordingly.
>
> KHogwood-Thompson Wrote:
> > Hi All,
> >
> > I am trying to compare two spreadsheets of text strings, I only want to
> > find
> > those that match content and case. Currently Excel says that they match
> > even
> > if the case is not matching ie
> >
> > Follow Up is not the same as Follow up
> >
> > But with my current standard vlookup statement, Excel returns these
> > values
> > as matching.
> >
> > Please can someone help.
> >
> > Thanks
> > --
> > K Hogwood-Thompson
>
>
> --
> starguy
> ------------------------------------------------------------------------
> starguy's Profile: http://www.excelforum.com/member.php...o&userid=32434
> View this thread: http://www.excelforum.com/showthread...hreadid=570257
>
>