Get instant live expert help on vlookup not exact match

“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”

Post your problem and you’ll get expert help in seconds.

Our professional experts are available now. Your privacy is guaranteed.

Here are some problems that our users have asked and received explanations on

how to exact match 2 columns with vlookup
Solved by Z. A. in 17 mins
Can you create a vlookup for fields containing the name rather than an exact match
Solved by K. J. in 28 mins
I need to get a vlookup to match on case here is an example of two different IDS a#A3A00000AQkRp a#A3A00000AQkRP when I do the vlookup it returns the second value which isn't an exact match but I've tried to use the exact match features but it never seems to work with vlookup.
Solved by E. L. in 20 mins
using index match, i am getting values that are for similar names but not exact
Solved by I. Q. in 16 mins
In cell I10, enter a VLOOKUP function that will convert the Satisfaction Rating to a grade found in the second column of the GradeScale named range. The formula is not looking for an exact match.
Solved by C. J. in 26 mins