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
Check your other post..
"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
yeah, go it. problem of chrome, it was not coming out of "Post" action and I
posted it again using IE. Regards, - Dharmesh "Jacob Skaria" wrote: Check your other post.. "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 | |||
Excel - changing column reference based on value of other column | Excel Discussion (Misc queries) | |||
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) |