Check content in cell and return value

1. Check content in cell and return value

Hi, I need to check if in cell A2 it contents any value from column E, if yes, return the value from column F. For example, the formula in B4 should be: find if "eau de per" from A4 is in any row from column E and return the value of its right cell from column F.

Thank you!

2. Re: Check content in cell and return value

In cell B2 enter

``Please Login or Register  to view this content.``
and copy down

3. Re: Check content in cell and return value

Hi, thank you but it only works if value is equal, I need if cell contents any value.

4. Re: Check content in cell and return value

The formula given should give you exactly what you have asked for.

5. Re: Check content in cell and return value

Hi, it gives errors, see new file please.

6. Re: Check content in cell and return value

Try this:

=IFERROR(LOOKUP(1000,SEARCH(\$E\$2:\$E\$5,A2),\$F\$2:\$F\$5),"")

7. Re: Check content in cell and return value

I think it's working, thanks!

No worries.

9. Re: Check content in cell and return value

Sorry dear, another question. If I want that the formula will search for more than 1 word that are not together. Any idea?

10. Re: Check content in cell and return value

Please provide sample data to show what you mean.

11. Re: Check content in cell and return value

Sure, please see attached in blue. The question is if there is a combination of words in a cell to set a specific value.

12. Re: Check content in cell and return value

This is getting too complex - how is Excel meant to know that it should ignore Eau de Perfume in this case and look at shampoo AND spray instead? What are the rules?

There are currently 1 users browsing this thread. (0 members and 1 guests)