| Home |
| Search |
| Today's Posts |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
What Function Should I Use. Is this a "What If" Type of Argument?
PS....
On Feb 9, 9:20*am, I wrote: Perhaps this will work for you: indirect(choose(First!$A$1, "Second!$A$1:$A$25", "Second!$B$1:$B$5")) (Of course, I had a typo: $B$5 should be $B$25.) If the ranges are always adjacent columns and the same number of rows, the following might work for you: offset(Second!$A$1:$A$25, 0, First!$A$1-1) |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| "Type mismatch" when I try to fill an Array variable with "+" | Excel Discussion (Misc queries) | |||
| how do I type "itis" without Excel putting a space "it is"? | Excel Worksheet Functions | |||
| When I type "BVE" in a cell, it automatically chanegs to"BE"..Why | Excel Discussion (Misc queries) | |||
| When I type "13" the spreadsheet shows "14." Possibilities? | Excel Discussion (Misc queries) | |||
| Where is the toolbar with the "bold type", "font type", options | New Users to Excel | |||
Threaded Mode
