+ Reply to Thread
Results 1 to 5 of 5

If cell matches Cell Range than enter text in another cell

  1. 01-19-2018, 08:23 PM #1
    BOB MUSE
    BOB MUSE is offline
    Registered User
    Join Date
    01-19-2018
    Location
    IRVINE
    MS-Off Ver
    10
    Posts
    2

    If cell matches Cell Range than enter text in another cell

    If Cell E1
    matches cell range J2:J6 then enter content of Cell J1
    matches cell J9 then enter content of Cell J8
    matches cell range J12:J22 then enter content of Cell J11

    Thanks in advance
    Reply With QuoteRegister To Reply
  2. 01-19-2018, 08:40 PM #2
    gmr4evr1
    gmr4evr1 is offline
    Forum Expert gmr4evr1's Avatar
    Join Date
    11-24-2014
    Location
    Texas
    MS-Off Ver
    Office 2010 and 2007
    Posts
    3,448

    Re: If cell matches Cell Range than enter text in another cell

    See if this works..
    Formula: copy to clipboard 
    Please Login or Register  to view this content.
    1N73LL1G3NC3 15 7H3 4B1L17Y 70 4D4P7 70 CH4NG3 - 573PH3N H4WK1NG
    You don't have to add Rep if I have helped you out (but it would be nice), but please mark the thread as SOLVED if your issue is resolved.

    Tom
    Reply With QuoteRegister To Reply
  3. 01-20-2018, 01:33 AM #3
    BOB MUSE
    BOB MUSE is offline
    Registered User
    Join Date
    01-19-2018
    Location
    IRVINE
    MS-Off Ver
    10
    Posts
    2

    Re: If cell matches Cell Range than enter text in another cell

    Excellent

    thanks so much
    Reply With QuoteRegister To Reply
  4. 01-20-2018, 01:58 AM #4
    AliGW
    AliGW is online now
    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
    80,786

    Re: If cell matches Cell Range than enter text in another cell

    If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.
    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.
    Reply With QuoteRegister To Reply
  5. 01-20-2018, 09:32 AM #5
    gmr4evr1
    gmr4evr1 is offline
    Forum Expert gmr4evr1's Avatar
    Join Date
    11-24-2014
    Location
    Texas
    MS-Off Ver
    Office 2010 and 2007
    Posts
    3,448

    Re: If cell matches Cell Range than enter text in another cell

    You're welcome.
    If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] If a range matches a cell, display text from another cell
    By DarrenCl in forum Excel General
    Replies: 3
    Last Post: 07-20-2017, 10:48 AM
  2. If cell matches any cell in range return a cell within the same row.
    By archilles89 in forum Excel Formulas & Functions
    Replies: 12
    Last Post: 01-16-2015, 10:57 AM
  3. populate cell with text from other cell that matches text from adjacent cell
    By completelyhis in forum Excel General
    Replies: 15
    Last Post: 12-05-2014, 01:14 AM
  4. Comparing Cell to Range, is it possible to display all matches found in a single cell?
    By WSICKLES44444 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 10-04-2013, 05:20 PM
  5. If Cell Text Matches Any Text From Range, Then Apply VLOOKUP?
    By eliot1171 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 04-12-2013, 09:41 PM
  6. Formula to Find If Text In a Cell Matches Another Range of Cells
    By purplesamcat in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 03-03-2013, 07:45 PM
  7. If cell X matches a value in a cell range, return "specific text" - HELP :(
    By paulandrewlee in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 01-02-2013, 07:06 PM

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1