+ Reply to Thread
Results 1 to 2 of 2

Search Range Within Cell or Cells

  1. #1
    Registered User
    Join Date
    06-01-2016
    Location
    CO
    MS-Off Ver
    2013
    Posts
    5

    Search Range Within Cell or Cells

    This is obviously my first post on here, so please forgive me if I don't do something right. I am trying to put together a sheet that has inputs for various chemical constituents of a steel, and I would like to determine which grade it is...see below example of what I'm trying to do. I need help with the formulas for searching a range of numbers and outputting if it falls into that category or not. I would love to do this without VBA but will default to the experts on here. Thanks in advance!

    Inputs

    Input 1
    C: 0.15
    Mn: 0.75

    Input 2
    C: 0.22
    Mn: 0.35


    Steel Grades

    L175 Grade
    C: 0.00 to 0.21
    Mn: 0.00 to 0.60

    L210 Grade
    C: 0.00 to 0.22
    Mn: 0.00 to 0.90

  2. #2
    Registered User
    Join Date
    06-01-2016
    Location
    CO
    MS-Off Ver
    2013
    Posts
    5

    Re: Search Range Within Cell or Cells

    I got some help, thanks!

+ 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. Search keyword in range of cells, then copy entire cell to another column
    By jreil563 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 08-13-2015, 12:46 PM
  2. Search for multiple words in range of cells...answer in adjacent cell
    By TheDudestMonk in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 08-13-2013, 07:49 AM
  3. [SOLVED] Search a range for cells that have values and set value in another cell based on results
    By Catsup in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 01-25-2013, 04:57 PM
  4. Search Function - Lookup from a cell in a range of cells
    By scottymelloty in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 10-13-2012, 08:56 AM
  5. Replies: 3
    Last Post: 08-16-2012, 03:25 PM
  6. Replies: 8
    Last Post: 03-03-2011, 03:28 PM
  7. Search range of cells, find a value, output adjoining cell. How?
    By nyys in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 01-05-2006, 09:55 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