+ Reply to Thread
Results 1 to 4 of 4

vlookup based on two results

  1. #1
    Registered User
    Join Date
    04-30-2014
    Location
    Australia
    MS-Off Ver
    Excel 2010
    Posts
    28

    vlookup based on two results

    I have a spreadsheet that has one drop down and then a dependent drop down. I then have a cell which needs to look up the result in the dependent drop down and relate it to the table in the drop down data sheet. There are four different columns that I need to get a result from but due to each column having some of the same results I need it to look at B17, then find the corresponding column in "Drop Down Data" then look at C17 and find the corresponding award rate in "Drop Down Data". Hopefully this makes sense.
    Attached Files Attached Files

  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
    53,048

    Re: vlookup based on two results

    1. Make your headings the exact same as what you have in the DD list
    2. Try this...
    =VLOOKUP(C17,OFFSET('drop down data'!$A$1,,MATCH('Pick list for staff'!B17,'drop down data'!$A$1:$AH$1,0)-1,10,2),2,0)
    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

  3. #3
    Registered User
    Join Date
    04-30-2014
    Location
    Australia
    MS-Off Ver
    Excel 2010
    Posts
    28

    Re: vlookup based on two results

    That worked perfect, thank you!

  4. #4
    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
    53,048

    Re: vlookup based on two results

    Happy to help

+ 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. Using vLookup based on results from a vLookup & returning an undetermined list
    By NormalityBan in forum Excel Formulas & Functions
    Replies: 15
    Last Post: 08-14-2014, 05:02 AM
  2. Change timestamp based on results of vlookup?
    By infopro247 in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-20-2012, 08:50 AM
  3. Vlookup results based on IF Function
    By numbersdntlie in forum Excel General
    Replies: 9
    Last Post: 12-21-2011, 01:24 PM
  4. Sum multiple results from a vlookup based on dropdown value
    By bdes in forum Excel - New Users/Basics
    Replies: 4
    Last Post: 09-27-2010, 12:20 PM
  5. Change formula based on results of vlookup
    By hutch@edge.net in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 07-25-2008, 04:19 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