Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|