Results 1 to 3 of 3

Formula to look at two columns, reference two others, then list a code for each cell

Threaded View

Lonniepoet Formula to look at two... 08-29-2014, 02:50 PM
ben_hensel Re: Formula to look at two... 08-29-2014, 03:18 PM
Lonniepoet Re: Formula to look at two... 08-29-2014, 03:26 PM
  1. #1
    Registered User
    Join Date
    08-29-2014
    Location
    Kansas City, MO
    MS-Off Ver
    2010
    Posts
    3

    Formula to look at two columns, reference two others, then list a code for each cell

    I have a spreadsheet with a column listing Lengths and another listing Widths. I need help building a formula that will look at the lengths and depths, then auto-generate which machine code the item goes to. If you look at my attached spreadsheet I have a little table in the top right listing-out the minimum lengths and widths for each machine. I would like the formula to choose the machine with the smallest sizes. For an example, in row 4 in L4 I would like it to generate code 701, even though it could also work for machine code 142. Any help would be much appreciated. Thank you.
    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. Dragging formula (cell reference) across columns
    By theraindew in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 06-12-2013, 01:51 PM
  2. Replies: 3
    Last Post: 05-23-2013, 06:23 AM
  3. [SOLVED] Replace absolute cell reference with Indirect cell reference in formula
    By Roothy in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 04-11-2013, 04:46 AM
  4. select mo/yr w/data validation list, insert celll entry into vba file reference code
    By ShannonHowell in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 12-10-2011, 04:07 AM
  5. Us Cell Content As Reference in Formula For List
    By clgustaveson in forum Excel General
    Replies: 4
    Last Post: 04-01-2011, 03:03 PM

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