Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Find Applicable Formula, then Use It
I have a formula that references a cell. Based upon that cell's conditions,
I want it to execute one of many possible formulaes. I tried using nested IFs, but I couldn't get around the 7 nested limitation. I tried using a Vlookup to reference a table that had the other formulas I wanted to then execute on the row the original cell data was in, but the formulas don't end up referencing that. Any ideas? -- -Mark |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Find Applicable Formula, then Use It
You'd need to tell us what all the conditions are and what formula
corresponds to each condition. Biff "MSYM" wrote in message ... I have a formula that references a cell. Based upon that cell's conditions, I want it to execute one of many possible formulaes. I tried using nested IFs, but I couldn't get around the 7 nested limitation. I tried using a Vlookup to reference a table that had the other formulas I wanted to then execute on the row the original cell data was in, but the formulas don't end up referencing that. Any ideas? -- -Mark |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Find Applicable Formula, then Use It
So the cells in column A can return any value between 1 and 100. I want a
column Z to perform one of 100 possible formulas based on the value in column A. The formulas are simple concantenates ignoring or not ignoring data in columns B thru Y based on the value in Column A. Does this satisfy your question or do I need to actually list the formulas? -- -Mark "T. Valko" wrote: You'd need to tell us what all the conditions are and what formula corresponds to each condition. Biff "MSYM" wrote in message ... I have a formula that references a cell. Based upon that cell's conditions, I want it to execute one of many possible formulaes. I tried using nested IFs, but I couldn't get around the 7 nested limitation. I tried using a Vlookup to reference a table that had the other formulas I wanted to then execute on the row the original cell data was in, but the formulas don't end up referencing that. Any ideas? -- -Mark |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Find Applicable Formula, then Use It
Create a 2 column lookup table. The left column contains the numbers 1 -100.
The right column contains the formula that corresponds to the particular number. Then, in column Z you'd use a lookup formula like this: =IF(A1="","",VLOOKUP(A1,$AA$1:$AB$100,2,0)) Where $AA$1:$AB$100 is the 2 column lookup table. Biff "MSYM" wrote in message ... So the cells in column A can return any value between 1 and 100. I want a column Z to perform one of 100 possible formulas based on the value in column A. The formulas are simple concantenates ignoring or not ignoring data in columns B thru Y based on the value in Column A. Does this satisfy your question or do I need to actually list the formulas? -- -Mark "T. Valko" wrote: You'd need to tell us what all the conditions are and what formula corresponds to each condition. Biff "MSYM" wrote in message ... I have a formula that references a cell. Based upon that cell's conditions, I want it to execute one of many possible formulaes. I tried using nested IFs, but I couldn't get around the 7 nested limitation. I tried using a Vlookup to reference a table that had the other formulas I wanted to then execute on the row the original cell data was in, but the formulas don't end up referencing that. Any ideas? -- -Mark |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Find Applicable Formula, then Use It
I should have been clearer. I can (and have) done what you are suggesting
below, but the end result is that the formula itself is pulled into the cell. What I actually need is the result of the aforementioned formula pulled into the cell. -- -Mark "T. Valko" wrote: Create a 2 column lookup table. The left column contains the numbers 1 -100. The right column contains the formula that corresponds to the particular number. Then, in column Z you'd use a lookup formula like this: =IF(A1="","",VLOOKUP(A1,$AA$1:$AB$100,2,0)) Where $AA$1:$AB$100 is the 2 column lookup table. Biff "MSYM" wrote in message ... So the cells in column A can return any value between 1 and 100. I want a column Z to perform one of 100 possible formulas based on the value in column A. The formulas are simple concantenates ignoring or not ignoring data in columns B thru Y based on the value in Column A. Does this satisfy your question or do I need to actually list the formulas? -- -Mark "T. Valko" wrote: You'd need to tell us what all the conditions are and what formula corresponds to each condition. Biff "MSYM" wrote in message ... I have a formula that references a cell. Based upon that cell's conditions, I want it to execute one of many possible formulaes. I tried using nested IFs, but I couldn't get around the 7 nested limitation. I tried using a Vlookup to reference a table that had the other formulas I wanted to then execute on the row the original cell data was in, but the formulas don't end up referencing that. Any ideas? -- -Mark |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Find Applicable Formula, then Use It
In the 2 column lookup table, the formulas in the right column should be the
*results* of that formula, not the literal TEXT string of the formula. Biff "MSYM" wrote in message ... I should have been clearer. I can (and have) done what you are suggesting below, but the end result is that the formula itself is pulled into the cell. What I actually need is the result of the aforementioned formula pulled into the cell. -- -Mark "T. Valko" wrote: Create a 2 column lookup table. The left column contains the numbers 1 -100. The right column contains the formula that corresponds to the particular number. Then, in column Z you'd use a lookup formula like this: =IF(A1="","",VLOOKUP(A1,$AA$1:$AB$100,2,0)) Where $AA$1:$AB$100 is the 2 column lookup table. Biff "MSYM" wrote in message ... So the cells in column A can return any value between 1 and 100. I want a column Z to perform one of 100 possible formulas based on the value in column A. The formulas are simple concantenates ignoring or not ignoring data in columns B thru Y based on the value in Column A. Does this satisfy your question or do I need to actually list the formulas? -- -Mark "T. Valko" wrote: You'd need to tell us what all the conditions are and what formula corresponds to each condition. Biff "MSYM" wrote in message ... I have a formula that references a cell. Based upon that cell's conditions, I want it to execute one of many possible formulaes. I tried using nested IFs, but I couldn't get around the 7 nested limitation. I tried using a Vlookup to reference a table that had the other formulas I wanted to then execute on the row the original cell data was in, but the formulas don't end up referencing that. Any ideas? -- -Mark |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Is this possible with excel ? | Excel Discussion (Misc queries) | |||
where to put results of find operation in find and replace functio | Excel Worksheet Functions | |||
Help! How do you get excel to find the x(changes daily, marked in a cell from another formula) highest numbers in a group of numbers and sum them up? | Excel Worksheet Functions | |||
Help! How do you get excel to find the x(changes daily, marked in a cell from another formula) highest numbers in a group of numbers and sum them up? | Excel Worksheet Functions | |||
copy and pasting a find all list into another column | Excel Discussion (Misc queries) |