Answer for:

Excel 2010 - VLOOKUP issue

Message 3 of 3

View entire thread
0 Votes

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