IF...i think
 

I am somewhat familiar with simple functions in Excel and I know there is a
way to do this but I need some help.

I have a worksheet (#1) with 4 columns,
column A goes from 61 to 99
columns B, C & D give the three ranges that refer to the number in column A
(e.g., column B=low percentage, C=midpoint, D=high percentage)

I want to link this worksheet(#1) to another worksheet (#2) where the answer
solved for is a number 61 to 99. Instead of looking up the three ranges I
would prefer to have these three ranges automatically listed next to the
answer that is solved for so that I can easily print out on one sheet the
range I am ultimately looking for.

Did I confuse you? I think I confused myself. Please help.

IF...i think
 

Hi
use VLOOKUP. See:
http://www.contextures.com/xlFunctions02.html

--
Regards
Frank Kabel
Frankfurt, Germany
"SJones" schrieb im Newsbeitrag
...
I am somewhat familiar with simple functions in Excel and I know there is a
way to do this but I need some help.

I have a worksheet (#1) with 4 columns,
column A goes from 61 to 99
columns B, C & D give the three ranges that refer to the number in column
A
(e.g., column B=low percentage, C=midpoint, D=high percentage)

I want to link this worksheet(#1) to another worksheet (#2) where the
answer
solved for is a number 61 to 99. Instead of looking up the three ranges I
would prefer to have these three ranges automatically listed next to the
answer that is solved for so that I can easily print out on one sheet the
range I am ultimately looking for.

Did I confuse you? I think I confused myself. Please help.