This is the second time I have had this happen to me. I am not sure how I fixed it the first time, but I have never seen a formula return a blank cell. Can someone help me with this issue? It HAS to be something simple, right????
On the attached spreadsheet I have the instructions on what I am trying to do. thanks for your help.
Are you still using Excel 2019?
MATCH requires a one dimensional array. It's returning an error, therefore a blank cell, as you have told it to!
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.
In L3 copied down:
=IFERROR(SUMPRODUCT(($C$3:$H$8=K3)*$B$3:$B$8),"")
I am sure that you can adapt it yourself for the V column.
Yes I am using the 2019 version of Excel. When you say that I need to use a dimensional array do you mean the formula should look like this?
{IFERROR(INDEX($B$3:$B$8, MATCH(K3, $C$3:$H$8, 0)), "")}
If so, I just did that and cell L5 still remains blank :-(
First...is my formula correct?
No, you are using MATCH incorrectly - read post #2 again.
$C$3:$H$8 is not correct - $C$3:$C$8 would be, but won't do what you want.
Solution in post #3.
thank you very much for figuring out my issue so quickly Ali!!! It is about 2:30AM so time to get to bed. Now I can sleep :-)
Glad to have helped.
Thanks for the rep and kind comment.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks