Hi,

I want to find multiple text from a set of data and show the data of some
other cell if the data is found.
Eg: Cell A1 contains data - Business class
Cell B2 contains Amount
In Cell C3 need a function which will show data of cell B2 if the
text "Business is found. I have used IF function and am able to get the same.
But, I was not successful in framing a single formula which could find
multiple text from the data and give me the above result.

Would be great if could you help me with this.

Thanks,

Amit