Here are some problems that our users have asked and received explanations on
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
Hi, I need to Vlookup an ID from one worksheet and match it to a name in a second worksheet, but the name format is not the same in both worksheets. Is there a Vlookup function to help with this?
Solved by M. F. in 18 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
Match a column to two similar columns, vlookup/match?
Solved by D. J. in 21 mins
I have two lists. One is a list of part numbers. The other is a list of long text descriptions. I can use VLOOKUP with "*"&cell address"*" to find the first match. But how can I find the second and third matches? I have tried using INDEX and SHORT but the wild cards no longer find the match like they do in VLOOKUP. Can you help?