Hi, I have managed to copy and get working the method of Automatically selecting a person name based on age and Country, this method found on this website, what I need to do is add a third variable, any ideas please. Below is the Two variable the third variable might be Department.

=INDEX($B$2:$B$5, SMALL(IF(COUNTIF($F$2, $C$2:$C$5)*COUNTIF($G$2, $D$2:$D$5), ROW($A$2:$D$5)-MIN(ROW($A$2:$D$5))+1), ROW(A1)), COLUMN(A1))

For my particular use I wish to bring in some dedicated Text instruction based on the three variables and or maybe a photograph.