| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
how to use vector name with a formula
For example, I want to a cell has a function of B$Text($C1)(grammar
mistake). If C1=1,B1=2,B2=3, the value for that cell is 3, the value of $B1, not "B1". Is there a way to implement this if the vector name has formula. Any help is appreciated. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
how to use vector name with a formula
I think you want:
=indirect("B"&$c1) Qing Xu wrote: For example, I want to a cell has a function of B$Text($C1)(grammar mistake). If C1=1,B1=2,B2=3, the value for that cell is 3, the value of $B1, not "B1". Is there a way to implement this if the vector name has formula. Any help is appreciated. -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Vector Perceptual Mapping | Charts and Charting in Excel | |||
| How do I draw 3D vector arithmetic, showing vector subtraction? | Excel Discussion (Misc queries) | |||
| How to use MATCH with a vector in VBA? | Excel Programming | |||
| Insert row for each different value in a vector | Excel Programming | |||
| from table to vector | Excel Worksheet Functions | |||
Linear Mode
