Thread: VLook Up Changing the Character
View Single Post
 
Old 08-21-2020, 11:58 PM
p45cal's Avatar
p45cal p45cal is offline Windows 10 Office 2019
Expert
  
Join Date: Apr 2014
Posts: 947
p45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond repute
Default
VLOOKUP is case insensitive.
One work-around is to use EXACT, so instead of:
=VLOOKUP(A6,$F$2:$G$5,2,FALSE)
use:
=INDEX($G$2:$G$5,MATCH(TRUE,EXACT(A6,$F$2:$F$5)))
which should be committed to the sheet using Ctrl+Shift+Enter, not just Enter (not needed on Office 365 versions).
Reply With Quote