ExcelBanter - Formula Query

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Formula Query (https://www.excelbanter.com/excel-discussion-misc-queries/226417-formula-query.html)

Pmcl

Formula Query

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

Formula Query

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

All times are GMT +1. The time now is 01:49 AM.