Case sensitive vlookup

Ctrl/shift/Enter this formula:
=INDEX(B1:B100,MATCH(TRUE,EXACT("YourStringHere",A1:A100),0))
is an equivalent case-sensitive =VLOOKUP("YourStringHere",A1:B100,2,False)
Bob Umlas
Excel MVP

"Tawe" <Tawe.1qkg2b_1118667902.4328@excelforum-nospam.com> wrote in message
news:Tawe.1qkg2b_1118667902.4328@excelforum-nospam.com...
>
> Excel treats uppercase and lowercase text as equivalent in a vlookup.
>
> Does anyone know how to avoid this, so that a vlookup formula doesn't
> treat uppercases and lowercases text as equivalent ?
>
> eg. the vlookup of "a" should give a different result than a vlookup
> for "A".
>
>
> --
> Tawe
> ------------------------------------------------------------------------
> Tawe's Profile:
http://www.excelforum.com/member.php...o&userid=24242
> View this thread: http://www.excelforum.com/showthread...hreadid=378512
>

Thanks, You've been a great help !!