Questions

Excel 2010 - VLOOKUP issue

+
0 Votes
Locked

Excel 2010 - VLOOKUP issue

abanerji
I have a problem in getting VLOOKUP to evaluate consistently. It is best understood from the screenshot linked (Office 2010), where cells B3 and B4 are not showing the expected values. I wanted to upload the excel file, but cannot see the option to do it.

The screenshot is at http://www.flickr.com/photos/abanerji/8547938172/in/photostream

This is just a small segment of the big excel sheet, and so a global solution is required.

How to get it right please?
  • +
    0 Votes
    gechurch

    I created a blank Excel document and typed the values and formula's in as per your screenshot and it works fine. I suspect there's something external getting in the way that's not visible from the screenshot you posted.

    I would start with a new Excel document and do what I did - type it in and get *something* working. Then start copying and pasting in bits from your original document until it breaks.

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

  • +
    0 Votes
    gechurch

    I created a blank Excel document and typed the values and formula's in as per your screenshot and it works fine. I suspect there's something external getting in the way that's not visible from the screenshot you posted.

    I would start with a new Excel document and do what I did - type it in and get *something* working. Then start copying and pasting in bits from your original document until it breaks.

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