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

 

[jtakw]

Hi,

I don't see why you don't post your formula as FDibbins requested, it's no more effort than to post a link.

VLOOKUP is prone to errors when there are multiple "close enough" matches, try INDEX with MATCH:

=IF($H$4="A",INDEX($BA$24:$BA$134,(MATCH(D38,$AY24:$AY134,0))),"")

Note that I also added value if false of "", change this to whatever you want, you didn't provide for a value if false in your VLOOKUP formula.

 

[FDibbins]

A few years ago, before I learned about INDEX/MATCH, I created a vlookup/hlookup that did the same thing, but it sure wasn't pretty. That's why I asked to see a sample of the formula

 

[Aladin Akyurek]

A few years ago, before I learned about INDEX/MATCH, I created a vlookup/hlookup that did the same thing, but it sure wasn't pretty. That's why I asked to see a sample of the formula

Nothing is wrong with VLOOKUP/HLOOKUP. They also allow to embed MATCH...

 

[FDibbins]

Nothing is wrong with VLOOKUP/HLOOKUP. They also allow to embed MATCH...

Didn't say there was, I just mentioned it. But back then, I did not know about INDEX or MATCH

 

[Jonmo1]

Cell F38 should show .3798 in stead of 5

Change the 3rd argument (2), to a 3

Probably a similar issue with the other formulas.

 

[jtakw]

Change the 3rd argument (2), to a 3

Probably a similar issue with the other formulas.

Good catch Jonmo1, didn't see the hidden Column.

 

[dxzaber]

Good catch Jonmo1, didn't see the hidden Column.

problem Solved ..Hidden column was the problem .Thanks A lot

 

[dxzaber]

Change the 3rd argument (2), to a 3

Probably a similar issue with the other formulas.

Problem Solved ..Hidden column was the problem .Thanks A lot

 

[jtakw]

You're welcome.