+ Reply to Thread
Results 1 to 2 of 2

Find value in a table based on two inputs

  1. #1
    Registered User
    Join Date
    09-23-2020
    Location
    Nevada
    MS-Off Ver
    Office 16
    Posts
    4

    Find value in a table based on two inputs

    I have a table of information that I need to be able to pull info out of. I am given a 3-4 digit number represented by the left-most column. So, for instance, row 3 shows 559. If the given input is 530, since it is greater than row 2's 459 but less than row 3's 559, the formula would look in row 3. Then I am given a number from 1-7. So the formula would need to look across row 3 until it comes to the column with that number in the top-most row and return the given value. I have provided two examples in my spreadsheet of the given variables and which value the formula would need to return.

    Any help would be much appreciated!

    Thanks!
    Attached Files Attached Files

  2. #2
    Forum Guru
    Join Date
    09-10-2017
    Location
    Chippenham, England
    MS-Off Ver
    365
    Posts
    12,096

    Re: Find value in a table based on two inputs

    How about
    Formula: copy to clipboard
    Please Login or Register  to view this content.
    This may need array entry depending on you version of Excel.

+ 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. [SOLVED] Find data from a table using 4 inputs
    By Frankie_The_Flyer in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 05-12-2022, 09:49 PM
  2. [SOLVED] Counting Customers Based on One Table & Inputs
    By askg in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 05-10-2021, 10:26 PM
  3. Calculate a grade based on inputs that are pulling from a table
    By kloesch6950 in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 10-28-2018, 03:21 AM
  4. Replies: 7
    Last Post: 04-15-2018, 10:19 AM
  5. [SOLVED] Pivot Table Refresh Based On Inputs From Cell A2
    By NeedForExcel in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 04-10-2015, 06:45 AM
  6. Populate table based on 3 inputs
    By Senthilerp in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-19-2009, 04:16 AM
  7. [SOLVED] Find value in table based on two inputs
    By AMDRIT in forum Excel General
    Replies: 3
    Last Post: 12-30-2005, 12:50 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