+ Reply to Thread
Results 1 to 2 of 2

if cell A value matches a value in Range B, return "TRUE" in cell C

  1. #1
    Registered User
    Join Date
    02-08-2020
    Location
    Scottish Borders, Scotland
    MS-Off Ver
    Office 365
    Posts
    7

    if cell A value matches a value in Range B, return "TRUE" in cell C

    The setup:

    'Sheet1'!E1:E35 contains 3-letter codes;
    'Sheet1'!L1:L35 contains blank cells that are ready for manual text entries (names);
    'Sheet2'!H2:H10 contains a list of *special* 3-letter codes.

    The desired result:

    When a 3-letter code on 'Sheet1'!E1:E35 coincides with a *special* 3-letter code on 'Sheet2'!H2:H10, the corresponding blank cell on THAT SAME ROW on 'Sheet1'!L1:L35 gets special formatting.

    I am relatively new to the 'higher' functions in excel, and I'm afraid this one is so far defeating me...
    Last edited by PUPIXCELLIUM; 02-08-2020 at 07:16 PM. Reason: no title!

  2. #2
    Forum Expert
    Join Date
    07-06-2004
    Location
    Northern California
    MS-Off Ver
    2K, 2003, 2010, O365
    Posts
    1,490

    Re: if cell A value matches a value in Range B, return "TRUE" in cell C

    Sheet1!L1: =COUNT(MATCH(E1,Sheet2!$H$4:$H$10,0))>0

    If this is for cell values, fill L1 down into L2:L35. If instead this would be for conditional formatting, don't enter this in the Sheet1!L1:L35 cells, but select that range with the L1 cell the active cell, and use the formula above for the conditional formatting FORMULA condition.

+ 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. [SOLVED] When one cell equals value of another cell, then third cell displays text of fourth cell?
    By spookymyo in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 01-12-2021, 02:12 PM
  2. [SOLVED] VBA Worksheet Change Event - Cell 1 (%) = Cell 2 ($) & Cell 2 ($) = Cell 1 (%)
    By jimmyw3 in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 07-16-2019, 02:56 PM
  3. [SOLVED] cell a function doing math on previous sheet, cell b - cell c result in cell d...
    By dad812 in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 08-08-2018, 08:20 AM
  4. Replies: 6
    Last Post: 01-23-2018, 04:49 AM
  5. Replies: 7
    Last Post: 02-05-2014, 02:20 AM
  6. Replies: 1
    Last Post: 11-06-2013, 02:56 AM
  7. Replies: 1
    Last Post: 11-03-2012, 09:05 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1