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