I'm trying to look up the value nearest to those in these cells in the Normnal Distribution Table, THEN, from the cell whose value that was just located in the table, add the value in Column A with the value in Row 6.
Example:
Cell O3=.0.1151, in the Table Cell K9 is the closest value (0.1141) to what we looked up. So, the cells that k9 is the intersection point are A9 and k6. I need to come up with a way to have excel calculate that scenerio based of a value in cells O3-O13 which excel uses to lookup in the table.

My workbook, which is part of a larger project, is included. I'm a psychology grad school student and after hours of doing the math I ASSUMED it would be a snap to get excel to do this for me...now I"ve spent HOURS trying to get this seemingly simple command to function