+ Reply to Thread
Results 1 to 8 of 8

Multiple If Formula

  1. #1
    Forum Contributor
    Join Date
    07-17-2012
    Location
    India
    MS-Off Ver
    Excel 2007, 2010
    Posts
    660

    Multiple If Formula

    Dear All,

    One way doing is to do multiple vlook up against each column. Just wanted to know if we have another option with straight forward formula to arrive at the value in table 1?

    image1.PNG

    Tried with below,
    Please Login or Register  to view this content.
    Greatly appreciated if anyone knows way around!!
    Attached Files Attached Files
    Last edited by shiva_reshs; 01-28-2021 at 07:52 PM.
    Keep the Forum clean :


    1. Use [ code ] code tags [ /code ]. It keeps posts clean, easy-to-read, and maintains VBA formatting.
    2. Show appreciation to those who have helped you by clicking * Add Reputation below their posts.
    3. If you are happy with a solution to your problem, mark the thread as [SOLVED] using the tools at the top.

  2. #2
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2003,2007,2010
    Posts
    32,362

    Re: Multiple If Formula

    If I understand correctly, you could use INDEX/MATCH/MATCH.

    Post a sample workbook. See the yellow banner at the top of the page.
    Trevor Shuttleworth - Excel Aid

    I dream of a better world where chickens can cross the road without having their motives questioned

    'Being unapologetic means never having to say you're sorry' John Cooper Clarke


  3. #3
    Forum Contributor
    Join Date
    07-17-2012
    Location
    India
    MS-Off Ver
    Excel 2007, 2010
    Posts
    660

    Re: Multiple If Formula

    Thanks TMS. added sample book.

  4. #4
    Forum Expert
    Join Date
    02-10-2019
    Location
    Georgia, USA
    MS-Off Ver
    Office 365
    Posts
    1,228

    Re: Multiple If Formula

    Try this in Cell C2 and copy down:

    =INDEX(Pivot!$B$2:$G$9,MATCH($A2,Pivot!$A$2:$A$9,0),MATCH($B2,Pivot!$B$1:$G$1,0))

  5. #5
    Forum Contributor
    Join Date
    07-17-2012
    Location
    India
    MS-Off Ver
    Excel 2007, 2010
    Posts
    660

    Re: Multiple If Formula

    Wow. Thank you so much. Helped my time on putting multiple Vlook up.

  6. #6
    Forum Contributor
    Join Date
    07-17-2012
    Location
    India
    MS-Off Ver
    Excel 2007, 2010
    Posts
    660

    Re: Multiple If Formula

    Hi,

    Applied same logic to arrive at minimum value of header? Am i doing something wrong?

    Please Login or Register  to view this content.

  7. #7
    Forum Expert
    Join Date
    02-10-2019
    Location
    Georgia, USA
    MS-Off Ver
    Office 365
    Posts
    1,228

    Re: Multiple If Formula

    Try this

    =MIN(INDEX(Pivot!$B$2:$G$9,,MATCH($B2,Pivot!$B$1:$G$1,0)))

  8. #8
    Forum Contributor
    Join Date
    07-17-2012
    Location
    India
    MS-Off Ver
    Excel 2007, 2010
    Posts
    660

    Re: Multiple If Formula

    Thank you.. Works pefect

+ 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] Retrieving multiple text strings based on multiple criteria (formula update)
    By McKneezy in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 03-24-2019, 08:52 PM
  2. [SOLVED] Need Excel formula to use INDEX and MATCH with multiple criteria's over multiple ranges.?
    By mchilapur in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 03-22-2017, 08:56 AM
  3. Vlookup Formula to update multiple exchange rates for multiple products
    By jocpatch in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 10-24-2016, 08:36 PM
  4. Formula to Sum 3 Column Values based on Multiple Criteria for Multiple Rows
    By RMerckling in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 08-19-2016, 07:46 PM
  5. Replies: 12
    Last Post: 02-10-2014, 11:59 AM
  6. Replies: 0
    Last Post: 11-08-2012, 01:07 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