| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Using a variable to point to a location
That's nice, Don. Thanks a lot.
John "Don Guillett" wrote in message ... where the name in g3 matches col d on the sheets tab. Or modify for a number instead. =INDEX(people!d:d,MATCH(g3,people!d:d,0))& " "&INDEX(people!e:e,MATCH(g3,people!d:d,0)) -- Don Guillett Microsoft MVP Excel SalesAid Software "John" wrote in message ... I want to point to a name by its index number: =NameSheet!D[VariableOfRowContainingNameIWant] The kind of formula I want to use is like this, only instead of the "12" I want to use a variable, like G3: =CONCATENATE(People!C12," ",IF(LEN(People!D12)0,CONCATENATE(People!D12, " ")),People!E12) I am trying to display a person's name using their number. I'd like to avoid going to Visual Basic. John |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Decimal point location | Excel Discussion (Misc queries) | |||
| how to set up a simple variable in Excel, but cell location independent | New Users to Excel | |||
| How to return a specific data point from a large array if I don't know the exact location? | Excel Discussion (Misc queries) | |||
| Set a range from a variable location | Excel Discussion (Misc queries) | |||
| Data point location | Charts and Charting in Excel | |||
![John[_29_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Hybrid Mode
