Results 1 to 12 of 12

Using two tables to arrive at the correct number

Threaded View

  1. #1
    Forum Contributor
    Join Date
    07-30-2017
    Location
    texas
    MS-Off Ver
    2016
    Posts
    123

    Using two tables to arrive at the correct number

    Greetings everyone! i hope that someone can help me with this problem.

    here is my problem:

    here is my problem:

    there are two tables listed above. If cell I1 is less than 25 and cell L1 is less than 13 then the index and match should point to table A1:F10
    however, if the cell is 26 or greater and L1 is greater than 13, then the index and match should point to table G4:L10

    on widths 24 and less, the formula that is currently in cell A1 seems to be working properly. I cannot get the formula to pick up the second table when the width is >24

    I have provided data validation in cells I1,J1 and L1 (cell color is dark green). These are the only cells that will\should be manually changed to affect the formula result


    please help!

    thanks in advance for your assistance.

    EXAMPLES TO TRY:
    if cell I1 is 24 and J1 is 30 and L1 is 10 - the formula should point to table 1 and give a result as 385.00
    If cell I1 is 26 and J1 is 30 and L1 is 10 - the formula should point to table 2 and give the result as 530.00


    I have attached a workbook for clarification

    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. Excel formula to start at one number and arrive at another
    By maxhecht2 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 03-29-2017, 10:06 AM
  2. Replies: 14
    Last Post: 01-26-2017, 03:30 AM
  3. Data tables not returning correct output
    By blaketus17 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 10-19-2016, 10:56 AM
  4. Replies: 0
    Last Post: 02-16-2016, 05:34 AM
  5. Replies: 1
    Last Post: 09-17-2012, 09:35 AM
  6. Combining two tables together, keeping correct format
    By impala096 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-06-2010, 12:51 PM
  7. [SOLVED] Anyone seen Pivot Tables with incorrect detail but correct total?
    By mickee in forum Excel General
    Replies: 0
    Last Post: 07-17-2006, 03:30 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