Formula Query

[Pmcl]

Hi all,
Not sure if this is possible but I have a range of data in column B1:B200
and a range of text in column A1:A200. I want to set a formula so that if
the data in any of the cells in column B equals a particular value then the
text from the relevant cell in column A is output

 

[Jacob Skaria]

C1 is the text to be seached in B
=INDEX(A1:B200,MATCH(C1,B1:B200,0),1)