I've been trying to get this formula to work for days now but can't seem to get it work. Using the following formula I found on the web
=IFERROR(INDEX($C$7:$J$50001,SMALL(IF(($A$7:$A$50001="Name")*($B$7:$B$50001="Yes or No"),ROW($2:$1001)-ROW($1:$1)),ROW($A1))),"")
Essentially, my data starts on Row 7 and i'm trying to import the value of a cell if it matches the name in Column A and has either "Yes" or "No" in column B. Also hiding any errors that it may generate.
Column A
Names
Column B
"Yes/No"
Column C
Value I'm trying to import
I got it to work for a few line items but doesn't work for every name, i'm guessing it has to do with the row function which i have no idea what to do with.
Help please!
Bookmarks