| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Using a cell value for a reference
I have a value in a cell. I want to get the value in another cell based on
this value. Say that the value in the first cell (A1) is 25. The cell I want is in column C in this case it would be C25. How do I specify that 25 is a row reference? This is EXACTLY what I want to do. Not some other type of lookup, EXACTLY this. Thanks, Joe B |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Using a cell value for a reference
=INDIRECT("C"&A1)
-- Gary''s Student - gsnu200721 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Using a cell value for a reference
That did it,
THANKS!!!!! Joe B "Gary''s Student" wrote: =INDIRECT("C"&A1) -- Gary''s Student - gsnu200721 |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Using a cell value for a reference
Another one:
=index(C:C,a1) WFBJoeB wrote: I have a value in a cell. I want to get the value in another cell based on this value. Say that the value in the first cell (A1) is 25. The cell I want is in column C in this case it would be C25. How do I specify that 25 is a row reference? This is EXACTLY what I want to do. Not some other type of lookup, EXACTLY this. Thanks, Joe B -- Dave Peterson |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Using a cell value for a reference
JUST GREAT!!!
Xcelsious doesn't support INDIRECT. This tool is SO lacking in functionality. Back to the drawing board.... Joe B "WFBJoeB" wrote: That did it, THANKS!!!!! Joe B "Gary''s Student" wrote: =INDIRECT("C"&A1) -- Gary''s Student - gsnu200721 |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Using a cell value for a reference
Using that how would I reference a cell in another worksheet in the same
document? Thanks, Joe B "Dave Peterson" wrote: Another one: =index(C:C,a1) WFBJoeB wrote: I have a value in a cell. I want to get the value in another cell based on this value. Say that the value in the first cell (A1) is 25. The cell I want is in column C in this case it would be C25. How do I specify that 25 is a row reference? This is EXACTLY what I want to do. Not some other type of lookup, EXACTLY this. Thanks, Joe B -- Dave Peterson |
|
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Using a cell value for a reference
Maybe...
=index('Other sheet name here'!x:x,a1) or =index(c:c,'other sheet name here'!a1) WFBJoeB wrote: Using that how would I reference a cell in another worksheet in the same document? Thanks, Joe B "Dave Peterson" wrote: Another one: =index(C:C,a1) WFBJoeB wrote: I have a value in a cell. I want to get the value in another cell based on this value. Say that the value in the first cell (A1) is 25. The cell I want is in column C in this case it would be C25. How do I specify that 25 is a row reference? This is EXACTLY what I want to do. Not some other type of lookup, EXACTLY this. Thanks, Joe B -- Dave Peterson -- Dave Peterson |
|
#8
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Using a cell value for a reference
Dave,
Here's the final working version: =IF(INDEX(data!A:A,$C$4) = $C$1,INDEX(data!D:D,$C$4),"") Thanks again, Joe B "Dave Peterson" wrote: Maybe... =index('Other sheet name here'!x:x,a1) or =index(c:c,'other sheet name here'!a1) WFBJoeB wrote: Using that how would I reference a cell in another worksheet in the same document? Thanks, Joe B "Dave Peterson" wrote: Another one: =index(C:C,a1) WFBJoeB wrote: I have a value in a cell. I want to get the value in another cell based on this value. Say that the value in the first cell (A1) is 25. The cell I want is in column C in this case it would be C25. How do I specify that 25 is a row reference? This is EXACTLY what I want to do. Not some other type of lookup, EXACTLY this. Thanks, Joe B -- Dave Peterson -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Nesting a sheet name reference within a cell reference??? | Excel Discussion (Misc queries) | |||
| Formulas that reference cells that reference another cell | Excel Discussion (Misc queries) | |||
| absolute cell reference A spreadsheet cell reference that does no | Excel Discussion (Misc queries) | |||
| problem with cell reference in =sum(offset(cell reference,x,y,z,a)). Want cell ref to be variable. | Excel Worksheet Functions | |||
| Problem with =sum(offset(cell reference,w,x,y,z). I want cell reference to be variable | Excel Worksheet Functions | |||
Linear Mode
