Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I set up a formula with a changing range in an excel macro
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I set up a formula with a changing range in an excel macro
You need to post a bit more detail than that...
Are you asking for a VBA formula or a formula to put into a cell? By changing range, do you mean the range that the formula goes into changes, or a range reference used as a reference in the formula changes? In article , cinvic wrote: |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I set up a formula with a changing range in an excel ma
I don't know what his question was, but I have one along the same lines.
I am trying to write a vlookup formula where the table_array is a range name that can change based on other information in the same row. For example, if the service line in the current row is "business incentives", I want to look in a range name called "business_incentive". But if it is "employment tax", I want to look in the range name called "employment_tax". Business_incentives and employment_tax are ranges that are defined elsewhere in the workbook. Thanks for any help you can provide to me. "JE McGimpsey" wrote: You need to post a bit more detail than that... Are you asking for a VBA formula or a formula to put into a cell? By changing range, do you mean the range that the formula goes into changes, or a range reference used as a reference in the formula changes? In article , cinvic wrote: |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
excel 4.0 macro removal tool | Excel Discussion (Misc queries) | |||
Excel - return a picture or range rows as the result of a formula | Excel Worksheet Functions | |||
Putting numbers in excel without it changing into a formula? | Excel Worksheet Functions | |||
Is there a way to insert a formula, password or macro in an excel spreadsheet that will automatically delete the spreadsheet? | Excel Discussion (Misc queries) |