floating point error or match type issue??

[dwetzel]

Hello again,

I thought I had this figured out from my last inquiry but this one I just cannot understand.

Attached is my workbook with references to 2 sheets ELEV and KALK. In the KALK sheet, the 2 cells highlighted in yellow should be returning "-03" from the table in sheet ELEV. At the moment it only working for some elevations but not this one. all number cell in the formulas are being rounded to 3 significant figures, however the match is still not working (the rounding was the fix last time). I tried match type -1 and that really didn't work.

I hope this isn't some other Floating point error issue.

regards,
David

[TMS]

No, it's because 1111110 does not exist in the Lookup Table

[dwetzel]

The columns with the code that you are referring to are not associated with this problem. The cells that I highlighted in yellow contain the issue.

Attached is the workbook again for reference.

[Fluff13]

It is floating point errors, you need to round after doing the maths, in AL11 use
=IFERROR(IF(LEFT(M11,4)="ELEV","",(ROUND(W11-(AK11/2),3))),"")

[dwetzel]

jeez that seemed too easy for you
Problem solved! thank you for your help!
This forum is awesome, and fast. I hope to return the favor someday.
Thanks again and have a relaxed week.

warm regards,
David

[Fluff13]

You're welcome & thanks for the feedback.