anandbohra
04-30-2008, 04:24 AM
Hi friends
pl guide me how to accomplish this through Indirect funtion
In my database in column a i put dates (trading dates) now when ever i put one date i want the formula to get the value immediately preceeding date
just look at this example
col a (sheet name "Master")
28-Dec-07 25-Apr-08 26-Apr-08 27-Apr-08 28-Apr-08 29-Apr-08 30-Apr-08
now when i put 30/04/2008 in A1 in sheet named "output" i want a2 to show me 29/04/2008
& if i put 25/04/2008 in A1 in sheet named "output" i want a2 to show me 28/12/2007
now through address formula i am able to extract the addree
=ADDRESS(MATCH(a1,Master!$A$2:$A$65536,0)-1,1)
output comes say $A$6
now pl help me in accomplishing this formula
=INDIRECT("'"Master&"'!&value(ADDRESS(MATCH(a1,Master!$A$2:$A$65536,0)-1,1))")
the above one is wrong pl help me in getting right one (whats wrong in above formula???)
pl guide me how to accomplish this through Indirect funtion
In my database in column a i put dates (trading dates) now when ever i put one date i want the formula to get the value immediately preceeding date
just look at this example
col a (sheet name "Master")
28-Dec-07 25-Apr-08 26-Apr-08 27-Apr-08 28-Apr-08 29-Apr-08 30-Apr-08
now when i put 30/04/2008 in A1 in sheet named "output" i want a2 to show me 29/04/2008
& if i put 25/04/2008 in A1 in sheet named "output" i want a2 to show me 28/12/2007
now through address formula i am able to extract the addree
=ADDRESS(MATCH(a1,Master!$A$2:$A$65536,0)-1,1)
output comes say $A$6
now pl help me in accomplishing this formula
=INDIRECT("'"Master&"'!&value(ADDRESS(MATCH(a1,Master!$A$2:$A$65536,0)-1,1))")
the above one is wrong pl help me in getting right one (whats wrong in above formula???)