i have data that is case sensitive, and a vlookup function needs to
differentiate between for examle two values like 'tree' and Tree'.
is it possible to force the vlookup function to match case? thanks
i have data that is case sensitive, and a vlookup function needs to
differentiate between for examle two values like 'tree' and Tree'.
is it possible to force the vlookup function to match case? thanks
Try...
=VLOOKUP("Tree",IF(EXACT(A1:A10,"Tree"),A1:B10),2,0)
or
=INDEX(B1:B10,MATCH(TRUE,EXACT(A1:A10,"Tree"),0))
Both formulas need to be confirmed with CONTROL+SHIFT+ENTER, not just
ENTER.
Hope this helps!
In article <[email protected]>,
"alan" <[email protected]> wrote:
> i have data that is case sensitive, and a vlookup function needs to
> differentiate between for examle two values like 'tree' and Tree'.
>
> is it possible to force the vlookup function to match case? thanks
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks