Results 1 to 6 of 6

Index and Match with based on IF then condition?

Threaded View

  1. 09-08-2014, 05:59 PM #5
    aglander
    aglander is offline
    Registered User
    Join Date
    04-11-2014
    Location
    United States
    MS-Off Ver
    Excel 2007
    Posts
    3

    Re: Index and Match with based on IF then condition?

    Sure thing. A ton of formulas go into getting the data so but I pasted it as values here to make things simple (I am unable to change the format). Data -> Pivot -> Pivot Values (paste as values, clean, sort) -> 'Aviation' tab (Desired Output).

    I am open to any suggestions you have to make this easier. Thanks for taking a look!
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Sort index match if condition
    By Ravenousdead in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 06-09-2014, 12:24 PM
  2. Problems with multi-criteria Index/Match. LOOKUP works. Index/Match, SUMPRODUCT,ARRAY fail
    By sfike in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 04-30-2014, 02:42 AM
  3. [SOLVED] Vlookup (IFS) 3 Condition Model Using Index /Match
    By Winship in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 02-28-2014, 07:06 PM
  4. Index Match based on 2 Criteria only returning 1 match
    By stsanders22 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 12-04-2012, 11:26 PM
  5. Using INDEX, MATCH, but need condition
    By philiphales in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 01-25-2005, 10:27 AM

Tags for this Thread

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1