LinkBack URL
About LinkBacks
Hello
In the attached sample, in summary sheet, for Quant Large and Mid Cap Fund, the value 2000 should come automatically from sheet SIP.
How can I do this please
Hello
In the attached sample, in summary sheet, for Quant Large and Mid Cap Fund, the value 2000 should come automatically from sheet SIP.
How can I do this please
Why 2000 and not ANY other value (e.g. the 1000 in the same column)?
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU
Since you didn't tell us the criterion for choosing the date... this returns the value corresponding to the highest date:
=INDEX(INDEX(SIP!$D$3:$F$10,,MATCH($B3,SIP!$D$2:$F$2,0)),MATCH(MAX(SIP!$B$3:$B$10),SIP!$B$3:$B$10,0))
Thank You lots, you are right as alwaysOriginally Posted by Glenn Kennedy
As per my thinking. See the attachment.
I have create additional column in SIP sheet month / year
In summary "E1" to "P1" enter month number
In summary "E2" to "P2" enter year number
IN "E3"Formula:
Please Login or Register to view this content.
copy paste across
If you enter expected result manually then easy to understand.
atul
If my answer (or that of other members) has helped you, please say "Thanks" by clicking the Add Reputation button at the foot of one of their posts.
Also: if your problem is solved, please take the time to mark your thread as SOLVED by going to the top of your first post, selecting "Thread Tools" and then "Mark thread as solved".
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks