One way:

=INDEX(Sheet2!B1:B10,MATCH(TRUE,EXACT(A1,Sheet2!A1:A10),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.)

My table was in Sheet2!A1:A10.
My value to look up was in A1 (of sheet1).

You can extend the range, but don't use the whole column.



Tawe wrote:
>
> 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

--

Dave Peterson