ExcelBanter - can vlookup be forced to make a case sensitive match?

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - can vlookup be forced to make a case sensitive match? (https://www.excelbanter.com/excel-discussion-misc-queries/46642-can-vlookup-forced-make-case-sensitive-match.html)

alan

can vlookup be forced to make a case sensitive match?

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

Domenic

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 ,
"alan" 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

All times are GMT +1. The time now is 01:21 AM.