LinkBack URL
About LinkBacks
Updated the file
Updated the file
Last edited by Goodvibe; 01-23-2021 at 03:45 PM.
Projection
D2=IFERROR(LOOKUP(2,1/(MONTH('Épargnes Inv.'!$A$14:$A$35)=MONTH(Projection!D$1))/(YEAR('Épargnes Inv.'!$A$14:$A$35)=YEAR(Projection!D$1))/('Épargnes Inv.'!$C$14:$C$35=Projection!$A2),'Épargnes Inv.'!$G$14:$G$35),"")
copy across and down
Hi CARACALLA!
Thanks for the feedback! I'm trying to replicate the formula in the real table but it doesn't work on the real one. The columns are in the same order. It is just ROW reference number of the cells and the values that are different. Could you explain to me the "2;1" right after the LOOKUP function please? Maybe that's the issue?
Dates are numbers or texts like in your original file ?
In the file sent I changed the dates which were texts to real dates (numbers) and formatted to indicate month and year
It's my mistake. I have fixed both the column and the row for the month reference ($D$1). Just tried june and it works (since prior months don't have data). Thanks for helping me out Caracalla!
Last edited by Goodvibe; 01-22-2021 at 05:48 PM.
attach the real file
For Excel in English your dates are recognized as texts
Last edited by CARACALLA; 01-22-2021 at 05:52 PM.
You are welcome
The enigmas that I have and still trying to figure out:
1)Return the balance of LAST MONTH and THIS MONTH for each accounts (it would update as the months go by) in the tab named "Projection"
2)The latest balance for each accounts from the latest date that is in the table (in the tab named "Épargnes et Inv.)
Your help is greatly appreciated !Wish I could do more on my side regarding formulas but no luck so far :S!
Last edited by Goodvibe; 01-23-2021 at 10:57 AM. Reason: missing formula
I am still trying to figure out two formulas :S:
1)Return the balance of LAST MONTH and THIS MONTH for each accounts (it would update as the months go by) in the tab named "Projection"
2)The latest balance for each accounts from the latest date that is in the table (in the tab named "Épargnes et Inv.)
Your help is greatly appreciated
P.S. I have linked the attachment in the original post because I don't know to attach it in the reply section (a newbie to the forum :P)
You attach workbooks in exactly the same way in any post - instructions are at the top of the page.
Please don't post edit the content of posts - I will reinstate the contents of your opening post.
Please don't open duplicate threads - your duplicate of this has been closed.
Administrative Note:
Welcome to the forum.
Although we value your privacy as much you do, it could be important that members have a rough idea of your location as the solutions they offer may be affected by your locale. For instance, you might in the future post questions which are related to your regional settings.
With this in mind, please update your profile to something more precise (something such as UK, Europe, USA, UAE, etc. will suffice).
Thank you for helping us to help you.
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help. It's a universal courtesy.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
NB: as a Moderator, I never accept friendship requests.
Forum Rules (updated August 2023): please read them here.
Hi AliGW!
Oups! I didn't know regarding duplicate (sorry)! Since I have marked "issue solved" (regarding one formula) here in the post, I actually had a second formula to find regarding the same type of issue (return value of latest balance) in another tab. I thought that maybe people would move on after seeing "issue solved" :S. That is why I did another thread. What should I do in that situation? Editing the message "Issue solved"?
You have removed the solved tag, so that's fine.
Please update your forum location profile as requested - I'm guessing you are either in France or French-speaking Canada. Thanks.
Ok just edited the "issue solved" and updated my location. But how do we delete a reply instead of editing it?
Thanks for letting me know regarding the rule of duplication.
You don't delete replies - just add new messages to the thread to keep everything easy to follow and chronological. In fact, we much prefer you not to delete anything - it just leads to confusion.
Once this thread is solved, you can select Thread Tools from the menu link above and mark this thread as SOLVED.
Thanks for updating your location.
Ok makes sense! Thanks for the information. I will change the status to SOLVED once it is complete.
Épargnes Inv
D6=IFERROR(LOOKUP(2,1/('Épargnes Inv.'!$C$14:$C$35='Épargnes Inv.'!$C6)/('Épargnes Inv.'!E$14:E$35<>""),'Épargnes Inv.'!E$14:E$34),"")
Copy across and down
Thanks a lot Caracalla
I don't know if you saw the formulas that I am still trying to figure out in the tab "Projection"?
And to try to be more litterate for formula composition :P, can you explain the functions you used in the formula:
D6=IFERROR(LOOKUP(2,1/('Épargnes Inv.'!$C$14:$C$35='Épargnes Inv.'!$C6)/('Épargnes Inv.'!E$14:E$35<>""),'Épargnes Inv.'!E$14:E$34),"")???
No offense if you don't want to explain either by the way
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks