• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Help with Search Formula

S

Segurde

New Member
Hello,
I am looking to put together a formula that searches for a string of text and returns the following:
IF SEARCH “X Rewards” returns “X Rewards”
IF SEARCH “Gas Rewards” returns “Gas Rewards”
IF SEARCH “% OFF” returns “% Off”
IF SEARCH “0 Off” returns “Dollar Off”
 
Hi @Sequrde,

How is your data layout? Try this:

=INDEX(I$1:I$4,MAX(ISNUMBER(FIND(I$1:I$4,A1))*ROW(C$1:C$4),FALSE))

see this sheet.
 

Attachments

You must log in or register to reply here.
Back
Top