• 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.

formula to search a list for a keyword in another cell, then get a result from another cell

Afternoon all,

Hoping you can help with this one

I want to search a list for a set word. If found I want to pull the value from a specific cell

I've attached a sample sheet as an example

Thanks all

Brian
 

Attachments

  • search query.xlsx
    9.9 KB · Views: 6
Hi Bosco

Thanks for getting back to me.

I really wanted the result to be in cell G2

If the word C/lock from cell B2 appears in the list E2:E29, I wanted cell G2 to copy the number from cell C2

If the word doesn't appear in the list, return zero instead in cell G2

Regards

Brian
 
Hi Bosco

Thanks for getting back to me.

I really wanted the result to be in cell G2

If the word C/lock from cell B2 appears in the list E2:E29, I wanted cell G2 to copy the number from cell C2

If the word doesn't appear in the list, return zero instead in cell G2

Regards

Brian
Then,

In G2 :

=IF(COUNTIF(E2:E29,B2&"*")>0,C2,0)

Regards
Bosco
 
Back
Top