Kirstym1918
New Member
- Joined
- Dec 17, 2017
- Messages
- 45
Hi guys,
So I've created this formula below and its looking up a name for a match then returning the data from the cell next to it which is a rota'd work day so W or H or whatever else has been added to the rota (could be a variation on text at any one time)
Its looking in two columns which is why I've had to use the IFERROR formula with it (If its not in BB column then look in BE for match)
=IFERROR(INDEX(Mon!$BC$5:$BC$500,MATCH(FTE!$B3,Mon!$BB$5:$BB$500,0)),IFERROR(INDEX(Mon!$BF$5:$BF$500,MATCH(FTE!$B3,Mon!$BE$5:$BE$500,0)),""))
Is there a way for restricting what data the INDEX returns?
So I only want INDEX to return the data if it equals "H", "W" or "S" and leave blank if it is not equal to any of these.
Any ideas?
Many Thanks
So I've created this formula below and its looking up a name for a match then returning the data from the cell next to it which is a rota'd work day so W or H or whatever else has been added to the rota (could be a variation on text at any one time)
Its looking in two columns which is why I've had to use the IFERROR formula with it (If its not in BB column then look in BE for match)
=IFERROR(INDEX(Mon!$BC$5:$BC$500,MATCH(FTE!$B3,Mon!$BB$5:$BB$500,0)),IFERROR(INDEX(Mon!$BF$5:$BF$500,MATCH(FTE!$B3,Mon!$BE$5:$BE$500,0)),""))
Is there a way for restricting what data the INDEX returns?
So I only want INDEX to return the data if it equals "H", "W" or "S" and leave blank if it is not equal to any of these.
Any ideas?
Many Thanks