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.