Index and Match with more than one Match

J

John Moore

Hi guys, I am looking for a solution to an Index and Match problem I am
having. Im using the Index and Match as below using SMALL in front of the
index and Match, which returns every instance in a report ( Sheet 2 ) that
meets my criteria ( F$4 ), Sheet 2 column F is the first column I am
retrieving data from ,,,, what I want to do is have the formula return every
instance in the report that meets 2 criteria ,,, say product anme and product
type ( right now is returning product name only ). Anyone got any ideas if
this can be done with this formula or another?

=IF(ISERROR(SMALL(Sheet2!$C:$C,ROWS($F$4:F4))),"",
INDEX(Sheet2!F:F,MATCH(SMALL(Sheet2!$C:$C,
ROWS($F$4:F4)),Sheet2!$C:$C,0)))
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Index/match across multiple columns? 16
Index and Match 5
Complex match 1
INDEX and MATCH 1
Index/Match Lookup with a merged col 2
more re index and match 6
Match Copy/Paste Macro almost there 0
Index and match formulas 1

Top