C1 is the text to be seached in B
=INDEX(A1:B200,MATCH(C1,B1:B200,0),1)
--
If this post helps click Yes
---------------
Jacob Skaria


"Pmcl" wrote:

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