Forum Discussion
INDEX MATCH based on 2 criteria and to return multiple values
Hi all, I am having difficulty putting two logic together, that is have a formula that works to return the data from 2 criteria using simple Match logic, BUT having difficulty using multiple re...
Hi Sarah,
It looks like you incorrectly check second criteria. There are few approaches to extract rows from the list based on multiple criteria, e.g.
https://chandoo.org/wp/2014/11/10/formula-forensics-no-003b-lukes-reward-part-ii/
https://www.get-digital-help.com/2010/02/11/match-two-criteria-and-return-multiple-rows-in-excel/
Based on second one the formula could be
=INDEX($C$5:$Z$14, SMALL(IF(COUNTIF($A$1,$C$5:$C$14)*ISBLANK($K$5:$K$14), ROW($D$5:$Z$14)-MIN(ROW($D$5:$D$14))+1), ROW(A1)), COLUMN(A1)+1)
for the range as in attached sample