VLook Up Changing the Character

		Microsoft Office Forums > Microsoft Excel > Excel
VLook Up Changing the Character

FAQ

Thread Tools

Display Modes

08-21-2020, 11:58 PM

p45cal

Windows 10 VLook Up Changing the Character

Office 2019

Expert

Join Date: Apr 2014

Posts: 956

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).

« Previous Thread | Next Thread »

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
How to mix character sizes without changing line spacing?	buttonsrtoys	Word	3	03-29-2019 01:26 PM
Vlook up multiple sequence	Cryken	Excel	4	01-31-2017 08:45 AM
Detecting that previous character doesn't exist (i.e., present character is first in document)	Robert K S	Word VBA	15	08-01-2016 09:33 AM
How can select from a specific character to another character	mohsen.amiri	Word	2	02-19-2015 11:38 PM
VLook up search	Tralee6	Excel	4	08-07-2014 05:20 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 11:49 AM.