Forum Discussion
Solved
Help: Creating a List Based on Two Values From a Data Set
Hi! Struggling with a rather basic issue: I need to pull the name of a class in a list based on "Active" status. Here is how the data is laid out now: I want to be able to have a formula find ...
=INDEX($A$2:$A$5,SMALL(IF($B$2:$B$5="Active",ROW($B$2:$B$5)-1),D2))
This formula works in my sample file. The formula must be entered as an arrayformula with ctrl+shift+enter if someone doesn't work with Office 365 or Excel for the web or Excel 2021.
=INDEX($A$2:$A$5,SMALL(IF($B$2:$B$5="Active",ROW($B$2:$B$5)-1),D2))
This formula works in my sample file. The formula must be entered as an arrayformula with ctrl+shift+enter if someone doesn't work with Office 365 or Excel for the web or Excel 2021.
- This worked, thanks! Had an iddue with it picking Select instead of Active, but changed the -1 to -2 and it's working accurately! Thanks again!
