+ Reply to Thread
Results 1 to 2 of 2

INDEX MATCH with If statement

  1. 04-14-2015, 07:42 AM #1
    geliedee
    geliedee is offline
    Forum Contributor geliedee's Avatar
    Join Date
    10-14-2013
    Location
    Manila, philippines
    MS-Off Ver
    Excel 2007
    Posts
    399

    INDEX MATCH with If statement

    Hi all,

    Just wondering how can i add YEs or No in this index match that i have?

    =INDEX('80.Transportation Zone'!B:B,MATCH('EXTRACT&PREVAL'!A2,'80.Transportation Zone'!A:A,1))
    Reply With QuoteRegister To Reply
  2. 04-14-2015, 07:49 AM #2
    GC Excel
    GC Excel is offline
    Forum Expert
    Join Date
    08-02-2013
    Location
    Québec
    MS-Off Ver
    Excel 2003, 2007, 2013
    Posts
    1,412

    Re: INDEX MATCH with If statement

    Not sure this is what you want :

    Please Login or Register  to view this content.
    GC Excel

    If this post helps, then click the star icon (*) in the bottom left-hand corner of my post to Add reputation.
    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. [SOLVED] IF Statement with offset or index / match?
    By KMCurtis in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 10-21-2013, 12:14 PM
  2. Remove #N/A from IF statement with INDEX & MATCH
    By usc1382 in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 07-11-2013, 01:21 PM
  3. [SOLVED] If Statement (Match/Index)
    By usmanfarok in forum Excel General
    Replies: 12
    Last Post: 09-26-2012, 04:42 AM
  4. Index & Match with IF statement
    By reggie1000 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 12-20-2007, 01:49 PM
  5. Index() & Match() or just an if() Statement?
    By JustMe602 in forum Excel General
    Replies: 6
    Last Post: 12-12-2006, 04:24 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1