Results 1 to 4 of 4

If contained in the list return value

Threaded View

  1. #1
    Registered User
    Join Date
    07-01-2020
    Location
    Yerevan
    MS-Off Ver
    2010
    Posts
    44

    If contained in the list return value

    Hi All,

    I would like to write a formula such that a value of "High" is returned in Column B of sheet1 if the name of country in Column A is contained in the LIST OF COUNTRIES in another sheet (reference sheet).

    See the test workbook attached.
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Return a value if specific text is contained in range.
    By lilit2222 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 07-19-2021, 03:54 PM
  2. Replies: 2
    Last Post: 05-13-2021, 01:37 PM
  3. [SOLVED] Match 2 different text strings both contained in a cell, return value
    By excelforumkeys in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 06-19-2018, 05:08 PM
  4. Return a cell value if a date is contained in a range of cells
    By studio95 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 05-27-2016, 04:44 AM
  5. [SOLVED] How to Return Values Not Contained in a Range
    By Kerik in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 11-10-2015, 02:24 AM
  6. Replies: 4
    Last Post: 07-28-2015, 01:54 PM
  7. [SOLVED] Return a value if criteria contained in cell
    By jhicsupt in forum Excel General
    Replies: 7
    Last Post: 10-05-2005, 05:05 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