Hi, I've got some data in a sheet as below

Discipline
Management
Management
Management
Management
Management

Architect
Architect
Architect
Architect
Architect
Architect
is there a function I can use to return the range where the text in a given column (ie. A) matches 'Management' ?

i.e the result for the example above would be A2:A6 ?