| Home |
| Search |
| Today's Posts |
|
#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! |
| 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 | |||
Threaded Mode
