| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel - changing column reference based on value of other column
I am having a data in one of the worksheet, say "X"
in "Y", what I am trying to do is select particular column values of "X" based on some value of column "Y" so it says, value of 'Y'!F5, with 'X'!A3, where A3=5(row number of 'Y'!F5), now value of 'X'!A4='Y'!F('X'!A3)='Y'!F5 why I wants this is because when I change A3=6, I want 'X'!A4='Y'!F6 Any Idea how to do this? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Excel - changing column reference based on value of other column
Try
=INDIRECT("'Y'!F" & X3) Y is sheet name F is column Row number specified in cell X3 of the current sheet If this post helps click Yes --------------- Jacob Skaria "Dharmesh Patel" wrote: I am having a data in one of the worksheet, say "X" in "Y", what I am trying to do is select particular column values of "X" based on some value of column "Y" so it says, value of 'Y'!F5, with 'X'!A3, where A3=5(row number of 'Y'!F5), now value of 'X'!A4='Y'!F('X'!A3)='Y'!F5 why I wants this is because when I change A3=6, I want 'X'!A4='Y'!F6 Any Idea how to do this? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Excel - changing column reference based on value of other colu
Hi Jacob,
this worked perfectly, thanks a lot. a small query, if its possible to do further modification to below formula? =INDIRECT("'Y'!F" & (X3+5)) mean, wants to add 5 to value of X3, means it can refer colum F10 in one instance, in another it will refer F15. thanks in advance. with Regards, - Dharmesh "Jacob Skaria" wrote: Try =INDIRECT("'Y'!F" & X3) Y is sheet name F is column Row number specified in cell X3 of the current sheet If this post helps click Yes --------------- Jacob Skaria "Dharmesh Patel" wrote: I am having a data in one of the worksheet, say "X" in "Y", what I am trying to do is select particular column values of "X" based on some value of column "Y" so it says, value of 'Y'!F5, with 'X'!A3, where A3=5(row number of 'Y'!F5), now value of 'X'!A4='Y'!F('X'!A3)='Y'!F5 why I wants this is because when I change A3=6, I want 'X'!A4='Y'!F6 Any Idea how to do this? |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Excel - changing column reference based on value of other colu
Your fomula is correct...Try
X3 = 5 The below will refer F10 =INDIRECT("'Y'!F" & X3+5) If this post helps click Yes --------------- Jacob Skaria "Dharmesh Patel" wrote: Hi Jacob, this worked perfectly, thanks a lot. a small query, if its possible to do further modification to below formula? =INDIRECT("'Y'!F" & (X3+5)) mean, wants to add 5 to value of X3, means it can refer colum F10 in one instance, in another it will refer F15. thanks in advance. with Regards, - Dharmesh "Jacob Skaria" wrote: Try =INDIRECT("'Y'!F" & X3) Y is sheet name F is column Row number specified in cell X3 of the current sheet If this post helps click Yes --------------- Jacob Skaria "Dharmesh Patel" wrote: I am having a data in one of the worksheet, say "X" in "Y", what I am trying to do is select particular column values of "X" based on some value of column "Y" so it says, value of 'Y'!F5, with 'X'!A3, where A3=5(row number of 'Y'!F5), now value of 'X'!A4='Y'!F('X'!A3)='Y'!F5 why I wants this is because when I change A3=6, I want 'X'!A4='Y'!F6 Any Idea how to do this? |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Excel - changing column reference based on value of other colu
Hi Jacob, this also worked fine.
thanks for the help. with Regards, - Dharmesh "Jacob Skaria" wrote: Your fomula is correct...Try X3 = 5 The below will refer F10 =INDIRECT("'Y'!F" & X3+5) If this post helps click Yes --------------- Jacob Skaria "Dharmesh Patel" wrote: Hi Jacob, this worked perfectly, thanks a lot. a small query, if its possible to do further modification to below formula? =INDIRECT("'Y'!F" & (X3+5)) mean, wants to add 5 to value of X3, means it can refer colum F10 in one instance, in another it will refer F15. thanks in advance. with Regards, - Dharmesh "Jacob Skaria" wrote: Try =INDIRECT("'Y'!F" & X3) Y is sheet name F is column Row number specified in cell X3 of the current sheet If this post helps click Yes --------------- Jacob Skaria "Dharmesh Patel" wrote: I am having a data in one of the worksheet, say "X" in "Y", what I am trying to do is select particular column values of "X" based on some value of column "Y" so it says, value of 'Y'!F5, with 'X'!A3, where A3=5(row number of 'Y'!F5), now value of 'X'!A4='Y'!F('X'!A3)='Y'!F5 why I wants this is because when I change A3=6, I want 'X'!A4='Y'!F6 Any Idea how to do this? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Pasting Forumulas without changing row and/or column reference | Excel Discussion (Misc queries) | |||
| Stop cell reference in formula changing when insert column? | Excel Discussion (Misc queries) | |||
| Column Reference Based on Value | Excel Discussion (Misc queries) | |||
| Based on a condition in one column, search for a year in another column, and display data from another column in the same row look | Excel Discussion (Misc queries) | |||
| chart label reference based on the column number | Charts and Charting in Excel | |||
Linear Mode
