Formula issue

Susan van Niekerk

Hi

Can I …..

So in my Traceker Sheet- I want to return a co- ordinators email when the relevanant team is selected - when "White Collar is select in the Tracker sheet, return the correct Email from the data sheet

Adam Murphy

You can do this from another sheet using an index/match or an index/collect formula. Something like this should work: =INDEX(COLLECT({Co Ordinators Email}, {Team}, Team@row))

Adam Murphy

You can do this from another sheet using an index/match or an index/collect formula. Something like this should work: =INDEX(COLLECT({Co Ordinators Email}, {Team}, Team@row))