+ Reply to Thread
Results 1 to 12 of 12

Check content in cell and return value

  1. #1
    Forum Contributor
    Join Date
    03-18-2010
    Location
    FL
    MS-Off Ver
    Excel 2016
    Posts
    145

    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!
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    05-29-2020
    Location
    NH USA
    MS-Off Ver
    365
    Posts
    2,103

    Re: Check content in cell and return value

    In cell B2 enter

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

  3. #3
    Forum Contributor
    Join Date
    03-18-2010
    Location
    FL
    MS-Off Ver
    Excel 2016
    Posts
    145

    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. #4
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,091

    Re: Check content in cell and return value

    The formula given should give you exactly what you have asked for.
    Trevor Shuttleworth - Retired Excel/VBA Consultant

    I dream of a better world where chickens can cross the road without having their motives questioned

    'Being unapologetic means never having to say you're sorry' John Cooper Clarke


  5. #5
    Forum Contributor
    Join Date
    03-18-2010
    Location
    FL
    MS-Off Ver
    Excel 2016
    Posts
    145

    Re: Check content in cell and return value

    Hi, it gives errors, see new file please.
    Attached Files Attached Files

  6. #6
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    79,382

    Re: Check content in cell and return value

    Try this:

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


    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.

    Forum Rules (updated August 2023): please read them here.

  7. #7
    Forum Contributor
    Join Date
    03-18-2010
    Location
    FL
    MS-Off Ver
    Excel 2016
    Posts
    145

    Re: Check content in cell and return value

    I think it's working, thanks!

  8. #8
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    79,382

    Re: Check content in cell and return value

    No worries.

  9. #9
    Forum Contributor
    Join Date
    03-18-2010
    Location
    FL
    MS-Off Ver
    Excel 2016
    Posts
    145

    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. #10
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    79,382

    Re: Check content in cell and return value

    Please provide sample data to show what you mean.

  11. #11
    Forum Contributor
    Join Date
    03-18-2010
    Location
    FL
    MS-Off Ver
    Excel 2016
    Posts
    145

    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.
    Attached Files Attached Files

  12. #12
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    79,382

    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?

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 5
    Last Post: 03-14-2020, 03:58 AM
  2. Replies: 3
    Last Post: 05-11-2018, 12:39 PM
  3. [SOLVED] Dynamic check of cell content
    By Sparhawk111 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-12-2016, 11:31 AM
  4. [SOLVED] Using check box to display cell content but it only displays #value!
    By i.r.smith in forum Excel General
    Replies: 5
    Last Post: 09-08-2014, 08:00 AM
  5. [SOLVED] VB Code to check the content in cell
    By rizmomin in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-23-2014, 11:06 AM
  6. Replies: 4
    Last Post: 06-28-2013, 09:15 AM
  7. How to get button to check cell content
    By FoxIII in forum Excel General
    Replies: 1
    Last Post: 02-17-2009, 08:25 AM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1