`How can I get the next row value in a column if the return value already exist in the return column?
I’m trying to make a crew list that will automatically fill out a shift based on their team and operation skills.
So far I’ve managed to get the correct crew member, but that member can’t be covering multiple positions.
=@IFERROR(FILTER('data-sheet'!B3:B36;ISNUMBER(SEARCH(T35;'data-sheet'!K3:K36)+SEARCH(O15;'data-sheet'!M3:M36)));"No match found")
data-sheet'!B3:B36
is Crew list
T35 is Operation skill
'data-sheet'!K3:K36
is List containing operation skill for each crew member
O15 is Team
'data-sheet'!M3:M36
is List containing which team each crew member is on
Now I just need to make sure that a crew member doesn’t appear multiple times.
Try to google my way to an answer. But as I’m not skilled enough to understand every function in excel.`
Lehnskov is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.