I have a problem in getting VLOOKUP to evaluate consistently. It is best understood from the attached file (Office 2010), where cells B3 and B4 are not showing the expected values.
The screenshot is also at Book2 | Flickr - Photo Sharing!
This is just a small segment of the big excel sheet, and so a global solution is required.
How to get it right please?
Bookmarks