IF....i think
 

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.

IF....i think
 

One way ..

In Sheet2
assuming the range below is in A1:B4
("Answer" in B1)

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

Select B2:B4

Put in the formula bar:

=IF(B1="","",TRANSPOSE(VLOOKUP(B1,Sheet1!A:D,{2,3, 4},0)))

Array-enter the formula with CTRL+SHIFT+ENTER,
instead of just pressing ENTER
--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----
"SJones" wrote in message
...
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.

IF....i think
 

Hi
see your other post

--
Regards
Frank Kabel
Frankfurt, Germany
"SJones" schrieb im Newsbeitrag
...
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.