I am somewhat familiar with basic Excel functions but I need some help on a
worksheet I am working on.

I have a worksheet (#1) that has 4 columns: Column A has numbers listed 61
thru 99, Columns B, C & D are numerical ranges refering to Column A (e.g.,
Column B=low point, C=midpoint, D=high point)

In worksheet #2 I am solving for a number between 61 and 99 to ultimately
get my low point, midpoint and high point. What function would I use to
automatically list these ranges from worksheet #1?

Example

Answer: 65
Low Point: 36.25
Mid Point: 41.25
High Point: 46.25

Please help.