Hello everyone
I have a excel sheet where I have a table with name , product and month. My formula returns the various products associated with the name , but what I need is to associate name and month. Attached follow what I did.
Thanking someone for help
Try this array formula
=IFERROR(INDEX($C$2:$C$16;SMALL(IF(($B$2:$B$16=$I$2)*($D$2:$D$16=$K$2);ROW($B$2:$C$16)-ROW($B$2)+1);ROW(1:1)));"")
***Array formula must be entered by using key combination of CTRL+SHIFT+ENTER and not just ENTER
Or since you using Excel 2010 you can use this formula without CTRL+SHIFT+ENTER
=IFERROR(INDEX($C$2:$C$16;AGGREGATE(15;6;ROW($C$2:$C$16)-ROW($B$2)+1/($B$2:$B$16=$I$2)/($D$2:$D$16=$K$2);ROW(1:1)));"")
Last edited by AlKey; 02-28-2015 at 07:43 PM.
If you like my answer please click on * Add Reputation
Don't forget to mark threads as "Solved" if your problem has been resolved
"Nothing is so firmly believed as what we least know."
--Michel de Montaigne
It Works !!
Thank you very much
You're welcome and thank you for the feedback!
Last edited by AlKey; 02-28-2015 at 07:50 PM.
AlKey
Sorry but now only returns only a reference product . The same name that month has several references was that he needed. attached example
You made some changes to the formula that are wrong and did not adjust ranges to accommodate new data set.
=IFERROR(INDEX($C$3:$C$32;SMALL(IF(($B$3:$B$32=$J$3)*($D$3:$D$32=$L$3);ROW($B$3:$C$32)-ROW($B$3)+1);ROW(1:1)));"")
Last edited by AlKey; 02-28-2015 at 08:25 PM.
Is good working;
Once again thank you
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks