Vlookup not fetching data properly

[akrams]

Good Afternoon All,

I need help figuring out why my Vlookup is not working the way it should. In the attached screenshot of excel sheet, the vlookup command should show Aug-2009 but it is showing a different vale. All highlighted yellow are OK but all greens have some issue. Can someone please help me figure out if there is something wrong with the vlookup command.

Thanks a million.





http://img24.imageshack.us/img24/5500/vlookup.jpg
Please click this link to see a large image

 

[onlyadrafter]

Hello,

try adding a ,0 before the end bracket.

 

[VoG]

Try

=VLOOKUP(A1,B$1:D$38,2,FALSE)

 

[akrams]

Thanks a million. 0 & false works great. Thanks again.