Results 1 to 10 of 10

Determine if all criteria fit between numerial ranges (for Excel and Google Sheets)

Threaded View

  1. #1
    Registered User
    Join Date
    06-12-2020
    Location
    Asia
    MS-Off Ver
    Office 365 and Google Sheets.
    Posts
    5

    Determine if all criteria fit between numerial ranges (for Excel and Google Sheets)

    Here is the sample I have created.

    Column N is the only column that has input values.
    Column K is the result I want.

    Column C, E, I is the least acceptable value, column D, G, J is the largest acceptable value.

    K2 does not match because item1 is only acceptable at 2, while in columns M/N you see item1 is at 1. The items can repeat!!
    K3 also does not match because item3 is only acceptable at values between 1 to 4, while in columns M/N you see item3 at 6.

    So on.. All 3 of these critera have to be met in order to return a match as in K5.

    Any help here, this seems impossible I've been at it all day... Thanks a lot!
    Attached Files Attached Files
    Last edited by AliGW; 06-12-2020 at 06:16 AM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Determine if value falls between multiple ranges
    By T15K in forum Excel General
    Replies: 4
    Last Post: 01-20-2021, 03:25 AM
  2. Replies: 11
    Last Post: 02-12-2015, 10:44 AM
  3. Populating hidden rows based on numerial ranges.
    By Common Wealth in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 01-11-2013, 11:37 AM
  4. Replies: 10
    Last Post: 11-27-2012, 12:23 PM
  5. Replies: 1
    Last Post: 11-15-2012, 04:53 PM
  6. Replies: 3
    Last Post: 02-23-2012, 08:06 AM
  7. Replies: 2
    Last Post: 04-22-2011, 09:34 AM

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