Results 1 to 25 of 25

Vlookup two tables to choose from 3rd table

Threaded View

  1. #1
    Forum Contributor
    Join Date
    03-10-2009
    Location
    chicago illinois
    MS-Off Ver
    Excel 2010
    Posts
    127

    Vlookup two tables to choose from 3rd table

    I have a spreadsheet where I have two tables A5:C15 and A16 to C26. These tables calculate all the possible options for an item across a sheet and all the possible options down the sheet. I some how need to automatically calculate the "best" option to fit on a few different sheet sizes E5:F13. So in the attached the best option is 5 down and 3 across and that size would be 27.5625 x 31.5. These numbers will change based on sizes that are input on another screen but for example I am posting one example/ For this example in real life and manually I would want it to be associated with the 28 x 35 in E5:F13. Is there a formula to automatically select the max sizes from C6:C15 (in this case 27.5625) and max size from C17:C26 (in this case 31.5) and have it select the best option from E5:F13. The table from E5:F13 the width and length dimensions are tied together so the options are 18 x 22, 20 x 26, 27 x 32, 28 x 35 and 28 x 40. So it cant look at the table and then select 28 from the width and then 32 from the length. Hopefully this makes sense and can be done. Im sure it can but I have been working in the spreadsheet for a couple hours and my mind is drawing a blank.

    I apologize if the title is correctly worded too
    Attached Files Attached Files
    Last edited by sp1974; 05-30-2017 at 09:05 AM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Display Table via Dropdown. Vlookup across multiple tables.
    By DAE05 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 05-04-2017, 11:10 AM
  2. [SOLVED] Choose from tables
    By Andrew.Trevayne in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 01-09-2017, 10:35 AM
  3. [SOLVED] Vlookup & Choose
    By timbo1957 in forum Excel General
    Replies: 8
    Last Post: 03-22-2012, 10:21 AM
  4. Choose between numbers in different tables
    By johrm50 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-15-2011, 05:49 PM
  5. Excel 2007 : When should I choose IF, AND, VLOOKUP?
    By Garethrowe in forum Excel General
    Replies: 1
    Last Post: 02-01-2011, 08:11 AM
  6. [SOLVED] Vlookup or choose or?
    By Dean in forum Excel General
    Replies: 1
    Last Post: 01-12-2006, 02:25 PM
  7. Replies: 8
    Last Post: 01-02-2006, 07:40 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