Forum Discussion
Solved
Call a certain name in a cell IF certain conditions are met
Hello, I have three columns of data, name, gender and age. In a separate cell, I want to call show a name based on conditions on certain age and gender. For instance showing me the name of the pe...
Depends on version of Excel you use.
As variant, you may have 3 cells, with drop-down lists if desired, for min age, max age and gender. Based on them you FILTER() the names and wrap result by TEXTJOIN() for the case if more than one of such names.
I use Excel (office 365). Could you be able to share an example with me, please?
- Thanks very much, that works.
You are welcome, glad it helped