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?

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?

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?