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.<br /> <br /> =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))<br /> <br /> For my particular use I wish to bring in some dedicated Text instruction based on the three variables and or maybe a photograph.

全新

選擇正確圖片的三個變量

Excel

鮑勃羅利

週一，30 2023月

1 回复

5.6K訪問

投票

復原

嗨，我已經設法複製並開始使用根據年齡和國家自動選擇人名的方法，這個方法在這個網站上找到，我需要做的是添加第三個變量，請有任何想法。下面是兩個變量，第三個變量可能是部門。

=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))

對於我的特殊用途，我希望引入一些基於三個變量和/或照片的專用文本說明。