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

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.

2 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 . 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
2 total posts (Page 1 of 1)  

Related Discussions

Related Forums