+ Reply to Thread
Results 1 to 2 of 2

vlookup - not exact matches question

  1. #1
    Registered User
    Join Date
    04-15-2011
    Location
    gray
    MS-Off Ver
    excel 2007
    Posts
    52

    vlookup - not exact matches question

    I tried using a vlookup with 'approximate match' but it isn't quite giving me what I want.

    I have the following lookup table

    10 LOW
    15 MID
    30 HIGH

    If I have data of the following - with the standard Vlookup with TRUE in column C giving me the following results:

    JOHN 8 #n/a
    MIKE 28 MID

    I want to see what group they fall in? But I am really looking for anything that falls between 8-12 to be LOW, 13-18 MID, and 18 + HIGH. How do I build the lookup table and what formula do I use to give me my desired results? THANKS!!!

  2. #2
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,938

    Re: vlookup - not exact matches question

    Change your range to 0, 15,19

    TRUE (or 0) finds the next lowest value, if it cannot find an exact match. Your range has nothing less than 10, so it errors
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

+ 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. Replies: 0
    Last Post: 08-11-2012, 03:25 PM
  2. Trouble with exact matches!
    By tripvanwinkel in forum Excel General
    Replies: 3
    Last Post: 09-06-2011, 09:10 AM
  3. Finding not exact matches
    By anthonyrambo in forum Excel General
    Replies: 7
    Last Post: 07-08-2011, 03:37 PM
  4. Non exact matches in HLOOKUP
    By scaffdog845 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 10-27-2009, 11:28 AM
  5. finding exact matches using vlookup
    By Ekazakoff in forum Excel Formulas & Functions
    Replies: 13
    Last Post: 07-29-2006, 09:30 AM

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