Skip to main content
Support is Online
We're back! We are here to assist you. Please be patient, we will respond to your tickets shortly.
Official support hours
Monday To Friday
From 09:00 To 17:30
  Monday, 30 January 2023
  1 Replies
  4.7K Visits
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
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.