Question

Locked

Excel 2010 - VLOOKUP issue

By 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?

This conversation is currently closed to new comments.

3 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Answers

Collapse -

Your formula is fine

by gechurch In reply to Excel 2010 - VLOOKUP issu ...

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.

Collapse -

I found a way

by abanerji In reply to Excel 2010 - VLOOKUP issu ...

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.

Back to Software Forum
3 total posts (Page 1 of 1)  

Software Forums