Searching is not giving desired result

[dxzaber]

https://app.box.com/s/wrtv64g0fx4o0gexeott0ba12j1ykd0g

https://drive.google.com/open?id=0B1GJKIl2o1WZam5HZ25oRGo5TTA


Cell F38 should show .3798 in stead of 5
Cell F39 should show .4899 in stead of .8880
Cell F40 should show .5769 in stead of 1.3130


Can anyone explain

 

[jtakw]

Double post: http://www.mrexcel.com/forum/excel-questions/936909-vlookup-hlookup-not-giving-desired-result.html

 

[FDibbins]

You need to stay with your original thread, not post duplicates

You have posted pretty much the exact same thing as your other thread - you were asked some questions there that still need to be answered

 

[Macropod]

dxzaber: Please read our policy against asking essentially the same question in mutiple threads, per rule #12: http://www.mrexcel.com/forum/board-announcements/99490-forum-rules.html

Thread closed.