If this is your first visit, then welcome! Be sure to check out the FAQ by clicking the link above.Register here so that you can post in the forums or comment on the articles.
Just for completeness, this would be an AND lookup: =IFERROR(INDEX(A:A,AGGREGATE(15,6,ROW($A$1:$A$13)/(($C$1:$C$13="Production")*($D$1:$D$13="Forward")),ROWS($1:1))),"")...
Yep, that did it! Thank you so much, it works amazing!...
Maybe this? =IFERROR(INDEX(A:A,AGGREGATE(15,6,ROW($A$1:$A$13)/(($C$1:$C$13="Production")+($C$1:$C$13="Something Else")),ROWS($1:1))),"")...
That worked perfectly! Thank you! What if column C had more options to choose from and I wanted to allow for multiple variables to be looked...
And there he was, gone, with not one word of thanks for the solution offered. What happened to good manners and common courtesy, I wonder?...
Knowledge Base Articles By Category
Recent Forum Posts
Conditionally filling a table based on non-unique information from another table
Just for completeness, this would be an AND lookup:
AliGW Today, 03:35 PM=IFERROR(INDEX(A:A,AGGREGATE(15,6,ROW($A$1:$A$13)/(($C$1:$C$13="Production")*($D$1:$D$13="Forward")),ROWS($1:1))),"")...