Cell V5 in the tab Flatwise Acct in the attached file is giving an error. I used the exact formula in a similar file successfully. I don't know where I am going wrong. Any help will be appreciated.
Cell V5 in the tab Flatwise Acct in the attached file is giving an error. I used the exact formula in a similar file successfully. I don't know where I am going wrong. Any help will be appreciated.
You probably didnt enter it as an array formula.
Here's a non-array version:
=IFERROR(INDEX(Transactions!$D$3:$D$2000,MATCH(1,INDEX(($K$2=Transactions!$C$3:$C$2000)*($A5=Transactions!$A$3:$A$2000),0),0)),"")
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.
Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh
Glenn,
Thank you for such a prompt response, and apologies for a tardy reply. Your correction worked. Thankful for that. But that has raised another question - why did it work without an "IFERROR" earlier?
In the attached file, please see Column M of Indvl Stmnts tab. Index has worked perfectly without IFERROR.
Also I have an additional question. In Cell Q5 of Flatwise Acct Tab, the formula is returning True or False instead of the values in Columns C and D. What is the mistake I have made?
I am trying to attach the file, but it does not allow me. How do I upload the file?
Regards,
Vijay
You can attach a file the same way as you did the last time!!!
seriously though... remind yourself by reading the yellow banner (top of page).
Glenn,
I tried exactly the same way, but for some reason, the Attachment button just flicks back to disabled state. I've reached out to the admin for help on this. Hope they can help.
Regards,
Vijay
You did not read the banner. the attach icon button is not mentioned in the yellow banner, because it dies not work and has not worked for years.
Here are more detailed instructions.
Unfortunately the attachment icon doesn't work at the moment. So,... instead click on Go Advanced (below the Edit Window) while composing your reply, then scroll down to and click on Manage Attachments and the Upload window will open. Click on Browse and navigate to (and double-click) the file icon that you want to attach, then click on Upload and then on Close this Window to return to the Edit window. When you have finished composing your post, click on Submit Post.
Thank you Glenn,
I feel so foolish. Thanks again. I've attached the file. So back to my query....
How did the same formula work in Column M of Indvl Stmnts tab without IFERROR? What am I missing here?
And in the Cell Q5 of Flatwise Acct Tab, the formula is returning True or False instead of the values in Columns C and D. What have done wrong?
Regards,
Vijay
In Q5:
=IF(AND(TODAY()>A5,J$2="1 BHK"),C5,IF(AND(TODAY()>A5,J$2="2 BHK"),D5,""))
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.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
Dear Ali,
That worked! Thank you very much. Moving the AND made the difference. I'll need to understand how to use IF AND correctly together.
Thanks again,
Vijay
It's quite simple:
=IF(AND(one_thing=A,another_thing=B),value_if_true,value_if_false)
If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.
Also, you may not be aware that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of those who helped.
Glenn, Ali,
How do I mark this post as 'Solved'?
Regards,
Vijay
Read the third line of post #10 again.
Thanks Ali,
Done!
Best,
Vijay
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks