| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Cell reference with variable column
Hi all,
Is there a function or way to say A1 where A is a variable that comes from another cell to the other cell has just he column letter like B? Thanks, Michele |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Cell reference with variable column
=INDIRECT(C1&"1")
-- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "mjones" wrote in message ... Hi all, Is there a function or way to say A1 where A is a variable that comes from another cell to the other cell has just he column letter like B? Thanks, Michele |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Cell reference with variable column
If you put B in A5 then this formula will return what's in B1, if you put C
in A5 it will be C1 =INDIRECT(A5&1) -- Regards, Peo Sjoblom "mjones" wrote in message ... Hi all, Is there a function or way to say A1 where A is a variable that comes from another cell to the other cell has just he column letter like B? Thanks, Michele |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Cell reference with variable column
Hi,
=INDIRECT(F1 & 6) If F1 contained the letter C then this would return the value of C6 Mike "mjones" wrote: Hi all, Is there a function or way to say A1 where A is a variable that comes from another cell to the other cell has just he column letter like B? Thanks, Michele |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Cell reference with variable column
On Apr 24, 3:36 pm, Mike H wrote:
Hi, =INDIRECT(F1 & 6) If F1 contained the letter C then this would return the value of C6 Mike "mjones" wrote: Hi all, Is there a function or way to say A1 where A is a variable that comes from another cell to the other cell has just he column letter like B? Thanks, Michele Thanks everyone! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Variable column reference in formula | Excel Discussion (Misc queries) | |||
| how do I use variable column and rows using other cell reference . | Excel Worksheet Functions | |||
| reference cell value from fixed column with variable row | Excel Discussion (Misc queries) | |||
| how to create a variable column in cell reference | 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
