Results 1 to 5 of 5

INDEX & MATCH for approximate matches or combine VLOOKUP & HLOOKUP

Threaded View

  1. #1
    Registered User
    Join Date
    11-26-2013
    Location
    Manila, Philippines
    MS-Off Ver
    Excel 2013
    Posts
    21

    Question INDEX & MATCH for approximate matches or combine VLOOKUP & HLOOKUP

    Hi guys,

    I need a way to look up the price if I input width and drop. Attached is a sample file. Sample.xlsx

    If I input a value for width and drop that is not present in the table, is there a way to return the next amount instead?

    Thank you!
    Last edited by michaljireht; 12-01-2014 at 08:12 PM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Index, Match, Vlookup, Hlookup or what?
    By ovgarcia24 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 09-22-2014, 07:07 PM
  2. Vlookup with Hlookup or Index with Match?
    By brad_x81 in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 08-08-2013, 06:40 AM
  3. Vlookup, HLookup, Index, Match, oh my! Help me.
    By ryanl in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 07-23-2013, 09:29 PM
  4. Vlookup Multiple Sheets, Approximate Matches
    By maxymab in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-28-2013, 09:50 PM
  5. Vlookup/hlookup/match/index?
    By margggggg in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 11-28-2012, 07:46 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