Monday, 30 January 2023
  1 Replies
  5.5K Visits
0
Votes
Undo
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.
1 year ago
·
#3379
0
Votes
Undo
Hello,
To lookup multiple matching values based on more criteria, please read the below article:

Vlookup all matching values based on two or more conditions vertically

Hope it can help you! :D
  • Page :
  • 1
There are no replies made for this post yet.