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?
- Follow via:
- RSS
- Email Alert
Question
Answers (2)
0
Votes
Your formula is fine
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.
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.
11th Mar
0
Votes
I found a way
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.
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.
11th Mar
