Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Using a variable to point to a location
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Using a variable to point to a location
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 |
#3
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 |