| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
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 |
|
#2
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| excel | Excel Worksheet Functions | |||
| make a vlookup using a variable path | Excel Worksheet Functions | |||
| Conversion | Excel Worksheet Functions | |||
| any way to make vlookup case sensitive? | Excel Worksheet Functions | |||
| Trying to make cell "date sensitive" to specific date | Excel Discussion (Misc queries) | |||
Linear Mode
