Skip to main content
Support is Offline
Today is our off day. We are taking some rest and will come back stronger tomorrow
Official support hours
Monday To Friday
From 09:00 To 17:30
  Monday, January 30, 2023
  1 Replies
  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.