| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
simlple question
In a cell F8 I have a number as for example: 3115
now in Cell M2 I want to say : =J3115 Problem is this 3115 number may change, so how M2 value change the J row number based on the new value? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
simlple question
Try the below in M2
="J"&F8 If this post helps click Yes --------------- Jacob Skaria "Darius" wrote: In a cell F8 I have a number as for example: 3115 now in Cell M2 I want to say : =J3115 Problem is this 3115 number may change, so how M2 value change the J row number based on the new value? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
simlple question
Oops ..
=INDIRECT("J" & F8) If this post helps click Yes --------------- Jacob Skaria "Jacob Skaria" wrote: Try the below in M2 ="J"&F8 If this post helps click Yes --------------- Jacob Skaria "Darius" wrote: In a cell F8 I have a number as for example: 3115 now in Cell M2 I want to say : =J3115 Problem is this 3115 number may change, so how M2 value change the J row number based on the new value? |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
simlple question
Check your other post for replies.
No need to multi-post in these news groups. Gord Dibben MS Excel MVP On Wed, 22 Apr 2009 10:09:01 -0700, Darius wrote: In a cell F8 I have a number as for example: 3115 now in Cell M2 I want to say : =J3115 Problem is this 3115 number may change, so how M2 value change the J row number based on the new value? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| where can I see my question and answer? Yesterday I ask a question | Excel Discussion (Misc queries) | |||
| If, then question | Excel Worksheet Functions | |||
| Add-In question | Setting up and Configuration of Excel | |||
| Newbie Question - Subtraction Formula Question | Excel Discussion (Misc queries) | |||
| The question is an excel question that I need to figure out howto do in excel. | Excel Worksheet Functions | |||
Hybrid Mode
