dynamic col reference
i am using excel 2007
I hv sheet as ff
A B C D E ....... X Y
1 15 22 18 33 5 ......
2
3
4
Depending on d value of X1, Y1 should get d value as ff
.
X1 Y1
1 15
2 22
3 18
4 33
this goes on for d rest of d rows, with diff values.
How can i do this?
Please don't use "text speak". It's one thing trying to work out what needs to be done without having to interpret your question.
Regards, TMS
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks