+ Reply to Thread
Results 1 to 3 of 3

Formula to use with multiple agruments to return result

  1. #1
    Registered User
    Join Date
    02-14-2017
    Location
    AUSTRALIA
    MS-Off Ver
    2016
    Posts
    1

    Formula to use with multiple agruments to return result

    I have a table where rows are numbered from 0-50 and the word Mates Rate down the page. Across the top are two column headings Group and Individual. Depending on who is to sign and the number of items required determines the price


    Number Required Group Individual

    42 25.50 28.50
    43 24.50 27.50
    44 23.50 26.50




    I want to be able to enter an agrument in a cell a number required ie 42, enter who is to sign ie Group whether it be a group or an individual and then have excel look up my table and return the cost
    The answer on my example should be 25.50

    I do not know how to get excel to look at the two agruments to determine the value

    Thanks in advance
    Attached Files Attached Files
    Last edited by WELLROCME; 02-14-2017 at 09:05 PM.

  2. #2
    Forum Guru Pete_UK's Avatar
    Join Date
    12-31-2011
    Location
    Warrington, England
    MS-Off Ver
    Office 2019 (still learning)
    Posts
    24,604

    Re: Which formula to use

    You can use this formula (e.g. in cell J14):

    =IFERROR(VLOOKUP($J$11,$A$9:$C$60,MATCH($J$12,$A$8:$C$8,0)),"")

    Hope this helps.

    Pete

  3. #3
    Forum Moderator jeffreybrown's Avatar
    Join Date
    02-19-2009
    Location
    Cibolo, TX
    MS-Off Ver
    Office 365
    Posts
    10,316

    Re: Which formula to use when wanting multiple agruments to return result

    Well, looks like Pete beat me, but here's another option. As you can see, many ways to go...

    =IFERROR(VLOOKUP($J$11,$A$9:$C$60,CHOOSE(MATCH($J$12,{"Group","Individual"},0),2,3),0),"")
    HTH
    Regards, Jeff

+ 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. [SOLVED] Formula to locate and match multiple data and return a result
    By hammer2 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 08-26-2015, 03:59 AM
  2. Search for Multiple Strings then Return Result
    By uberathlete in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 08-13-2015, 07:20 AM
  3. Replies: 7
    Last Post: 09-06-2013, 11:59 PM
  4. lookup multiple values in multiple columns to return a result
    By AYAHOO123 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 04-11-2013, 07:53 PM
  5. Replies: 3
    Last Post: 04-15-2010, 08:36 PM
  6. Date function agruments
    By KMTrombley in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-08-2010, 02:17 PM
  7. [SOLVED] Advanced formula - Return result & Show Cell Reference of result
    By Irv in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 05-05-2006, 10:40 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