Questions

Answer for:

Excel 2010 - VLOOKUP issue

Message 3 of 3

View entire thread
+
0 Votes
abanerji

Thanks for your reply.

Actually, I had wanted to upload the excel file.

I managed to do some research on the net, and found the best solution which worked for me from an MS blog http://blogs.office.com/b/microsoft-excel/archive/2010/06/10/solutions-to-three-common-problems-when-using-vlookup.aspx . Problem # 2 in this blog was my situation, and the solution was not tweaking the formula, but just doing a "text-to-columns" to globally convert the mixed text / number data which was there in the first column of the sheet.