Results 1 to 10 of 10

Lookup Column Title Using 2 Variables

Threaded View

  1. #1
    Registered User
    Join Date
    06-22-2016
    Location
    USA
    MS-Off Ver
    2007
    Posts
    3

    Lookup Column Title Using 2 Variables

    Howdy, i've been having trouble working out a formula to solve my current problem, hoped you folks could help.

    I have one sheet where i have a list of names, including their specialty and their income.
    John Doe Allergy/Immunology 195000

    on another sheet is a benchmark which lists specialties and incomes by percentile(like the following)

    Specialties 10 % tile 11 % tile 12 % tile
    Allergy/Immunology 189,971.17 194,055.58 196,723.75
    Anesthesiology 291,422.18 299,998.40 303,869.23



    What I would like to do is have a formula that produces an individual's pay percentile (column title). Specialties match exactly, but the incomes don't - (i'm fine with the nearest below or above) and ultimately returning the doc's percentile score - so '11 % tile' or '12 % tile' as the output for john doe.

    John Doe 11 % tile

    any help/advice you can provide would be appreciated!

    Thanks
    Last edited by stockmonkeys; 06-22-2016 at 03:40 PM. Reason: title is bad, data doesn't display well

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Challenge with the Index formula
    By I.am.Rustam in forum Excel General
    Replies: 14
    Last Post: 12-10-2015, 06:21 PM
  2. [SOLVED] Match-Index in stead of Index-Match lookup Array among Arrays
    By Numnum in forum Excel General
    Replies: 2
    Last Post: 10-15-2015, 02:08 PM
  3. Replies: 6
    Last Post: 04-30-2014, 02:42 AM
  4. Replies: 6
    Last Post: 11-08-2013, 10:29 PM
  5. [SOLVED] Index() Match() V/HLookup??? CHUGE Challenge! Up for it!? Need HELP!
    By BenCrockett in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 10-14-2013, 05:47 PM
  6. Replies: 3
    Last Post: 05-02-2013, 01:31 AM
  7. Table index challenge
    By Saturn in forum Excel General
    Replies: 3
    Last Post: 07-06-2012, 09:20 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