+ Reply to Thread
Results 1 to 3 of 3

LOOKUP - I need to lookup a value where the lookup vector is in any order

  1. #1
    Registered User
    Join Date
    05-19-2013
    Location
    South Africa
    MS-Off Ver
    Excel 2010
    Posts
    2

    LOOKUP - I need to lookup a value where the lookup vector is in any order

    Hi,

    I am trying to return a value (result vector) from a range of values (lookup vector) that are not in ascending or descending order.

    Please refer to the attached file:

    The sheet lists the age group in 5 years in totals and % for suburb, city and country. I am trying to return the age group that is the highest percentage in the suburb of Rosebank under "SUMMARY".

    The highest percentage in this case is the age group 20 - 24 at 35.1%. I have used the MAX function to return the highest age group percentage in the SUMMARY box. However when I attempt to use the LOOKUP function to return the age group of 20 - 24, it returns 85+ which is incorrect (RED BOX). Using the IF function returns the correct age group however this is tedious to write as I have a number of scenarios that need this function applied.

    Appreciate your assistance with this.
    Attached Files Attached Files

  2. #2
    Forum Guru benishiryo's Avatar
    Join Date
    03-25-2011
    Location
    Singapore
    MS-Off Ver
    Excel 2013
    Posts
    5,136

    Re: LOOKUP - I need to lookup a value where the lookup vector is in any order

    hi LukeMC, welcome to the forum. try:
    =INDEX(A13:A30,MATCH(K15,C13:C30,0))

    Thanks, if you have clicked on the * and added our rep.

    If you're satisfied with the answer, click Thread Tools above your first post, select "Mark your thread as Solved".

    "Contentment is not the fulfillment of what you want, but the realization of what you already have."


    Tips & Tutorials I Compiled | How to Get Quick & Good Answers

  3. #3
    Registered User
    Join Date
    05-19-2013
    Location
    South Africa
    MS-Off Ver
    Excel 2010
    Posts
    2

    Re: LOOKUP - I need to lookup a value where the lookup vector is in any order

    Hi,

    Great! Thank you

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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