How would you re-write this formula to avoid the #NUM! error showing in cells that don't display a query return ?
I understand it has to do with the Col / Row intersect (?) but not certain how to correct.
Please Login or Register to view this content.
Thanks for reading.
Post duplicated, and deleted.
Please consider:
Be polite. Thank those who have helped you. Then Click on the star icon in the lower left part of the contributor's post and add Reputation. Cleaning up when you're done. If you are satisfied with the help you have received, then Please do Mark your thread [SOLVED] .
Hello Logit,
Commit the formula with CTRL+Shift+Enter, don't just Enter.
Regards.
Hey Winon:
Already did that ... no go.
Here's the file.
Try this:
=IFERROR(INDEX($C$3:$C$20,SMALL(IF($J$2=$B$3:$B$20,ROW($B$3:$B$20)-MIN(ROW($B$3:$B$20))+1,""),ROW(A1))),"")
also confirmed with CSE.
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.
YES !!!!!
The wizard came thru again !
I tried something similar to that earlier but it didn't work. Maybe I didn't use C/S/E
Kudos to you
You're welcome!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks