Mod. original posted on thread: http://www.excelforum.com/excel-gene...n-z-table.html
Do not post questions in the threads of others
I'm trying to get these formulas working and I think there may be a flaw in the logic.
For the simple lookup, when 1.40 is entered, it should return the value 0.4192 (from Values!B16), but instead it's returning 0.4319 (from Values!K16).
For the harder lookup, when 0.49 is entered, it should return 2.33, but it's returning 2.32. The reason 2.33 is correct is because it's value (0.4901) is only .0001 from .49. Whereas 2.32's value of 0.4898 is .0002 from .49. I want it to return the value closest to the answer, not the one less than it.
Any ideas how to correct the formulas to return the above values I want them to return?
An excel doc is attached.
Many thanks in advance!
Bookmarks