+ Reply to Thread
Results 1 to 3 of 3

Nested if and index formula

  1. 06-19-2014, 07:52 AM #1
    vjharry
    vjharry is offline
    Forum Contributor
    Join Date
    11-10-2012
    Location
    India
    MS-Off Ver
    Excel 2003 to Excel 2010
    Posts
    235

    Nested if and index formula

    How can i use extract sub data from a large data.

    Reference file is attached to help me.
    Attached Files Attached Files
    Click on (*), if you agree.
    Reply With QuoteRegister To Reply
  2. 06-19-2014, 08:00 AM #2
    Hawkeye16
    Hawkeye16 is offline
    Valued Forum Contributor Hawkeye16's Avatar
    Join Date
    02-27-2013
    Location
    Holland
    MS-Off Ver
    ├•┤ Pew Pew
    Posts
    441

    Re: Nested if and index formula

    Try this in G2, press Ctrl + Shift + Enter and then copy over and down
    Formula: copy to clipboard 
    Please Login or Register  to view this content.
    Despite the high cost of living, it remains very popular.

    Don't forget to mark threads SOLVED when you get an answer and rep all the geniouses that helped you today!
    Reply With QuoteRegister To Reply
  3. 06-19-2014, 08:11 AM #3
    TheCman81
    TheCman81 is offline
    Valued Forum Contributor TheCman81's Avatar
    Join Date
    11-06-2012
    Location
    Edinburgh, UK
    MS-Off Ver
    Excel 2003, 2007, 2010, 2013
    Posts
    346

    Re: Nested if and index formula

    Is it someting like this? This is an array formula that requires Ctrl Shift Ent

    vjharry v1.xlsx
    Excel Guru in the making

    <----------If the question has been answered to your satisfication please click the Add Repuation star to the left
    Reply With QuoteRegister To Reply
+ Reply to Thread
« 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. Return the value of a cell/multiple criteria using nested INDEX, MATCH, IF array formula
    By Nic31 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 03-27-2014, 01:09 PM
  2. Help with nested Index Match formula
    By LilSisKin in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 11-09-2013, 06:10 PM
  3. Nested index formula - need to ignore errors
    By Fursmanm in forum Excel General
    Replies: 0
    Last Post: 09-20-2012, 09:50 AM
  4. [SOLVED] Intermittant #N/A error in nested vlookup index formula that shouldn't occur
    By DPKologie in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 09-01-2012, 04:25 PM
  5. Dependent Percentile Formula in Table with Nested Lookup or Index Match?
    By chogan in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 11-11-2010, 06:34 PM

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