Vlookup Hlookup is not giving desired result

[dxzaber]

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

Password: cfc47&

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

 

[FDibbins]

Cant access external links, can you show here what you are doing?
What does your formula look like?

 

[Aladin Akyurek]

What is the formula you are using? For providing a sample try rather: Attachments lists a few methods for posting sample exhibits which do not require retyping and the add-in https://app.box.com/s/soezox25h3w0q5s4rcyl is also a method for posting an exhibit, as a link to dropbox or onedrive does not provide a permanent record, not the cloud.

 

[dxzaber]

What is the formula you are using? For providing a sample try rather: Attachments lists a few methods for posting sample exhibits which do not require retyping and the add-in https://app.box.com/s/soezox25h3w0q5s4rcyl is also a method for posting an exhibit, as a link to dropbox or onedrive does not provide a permanent record, not the cloud.

https://www.dropbox.com/s/rougkeev55eec0r/WIND LOAD 2006.xlsx?dl=0 Try this link

Password : cfc47&

 

[dxzaber]

https://www.dropbox.com/s/rougkeev55eec0r/WIND LOAD 2006.xlsx?dl=0 try this link

Password : cfc47&

 

[Aladin Akyurek]

https://www.dropbox.com/s/rougkeev55eec0r/WIND LOAD 2006.xlsx?dl=0 try this link

Try rather a suggestion from post #3...

 

[dxzaber]

Try rather a suggestion from post #3...

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

 

[dxzaber]

Cant access external links, can you show here what you are doing?
What does your formula look like?

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

 

[FDibbins]

I just told you I cannot access external links - and you give me another 1?

I am not allowed/able to access external links (like to file-hosting sites)

You have been asked a couple of times to show what formula/s you are using?

 

[jtakw]

Posted again: http://www.mrexcel.com/forum/excel-questions/937017-searching-not-giving-desired-result.html