+ 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
    147

    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
    147

    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
    46,374

    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
    147

    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. 2410 (Windows 11 23H2 64-bit)
    Posts
    87,519

    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. It's a universal courtesy.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.

    NB:
    as a Moderator, I never accept friendship requests.
    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
    147

    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. 2410 (Windows 11 23H2 64-bit)
    Posts
    87,519

    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
    147

    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. 2410 (Windows 11 23H2 64-bit)
    Posts
    87,519

    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
    147

    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. 2410 (Windows 11 23H2 64-bit)
    Posts
    87,519

    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