I want to use a look up function to search my worksheet and find all the data that match a criteria.
I found this formula on a website [URL="http://www.myonlinetraininghub.com/excel-factor-17-lookup-and-return-multiple-matches"]
=IFERROR(INDEX($A$5:$B$11,SMALL(IF($A$5:$A$11=$E$4,ROW($A$5:$A$11)-4),ROW(A1)),2),"")
It's perfect for what I want to do, except the data I want to locate is non-numeric and SMALL will ignore non-numeric data. I don't want to use excel's filter, because I will have several of these formulas (if I ever figure out how to write it) on the same worksheet with multiple ranges across multiple worksheets. Any ideas?
Bookmarks