+ Reply to Thread
Results 1 to 2 of 2

If Statment with Index Match

  1. #1
    Registered User
    Join Date
    09-10-2013
    Location
    London
    MS-Off Ver
    Excel 2003
    Posts
    1

    If Statment with Index Match

    Hi

    I want to write an if statement based on whether the index match statment equals a figure greater than 0 - if so then I want to use the figure if not then I want to use another formula. The current formula gives me a value error.


    =INDEX(Stock!$B$5:$Y$14,IF(MATCH(TOTAL!$A$21,Stock!$A$4:$A$14,0),MATCH(TOTAL!D$7,Stock!$B$4:$Y$4,0))>0,INDEX(Stock!$B$5:$Y$14,MATCH(TOTAL!$A$21,Stock!$A$4:$A$14,0),MATCH(TOTAL!D$7,Stock!$B$4:$Y$4,0)),C21+C28-D10)

    I would appreciate any advice!

  2. #2
    Valued Forum Contributor tony h's Avatar
    Join Date
    03-14-2005
    Location
    England: London and Lincolnshire
    Posts
    1,187

    Re: If Statment with Index Match

    =if( OriginalIndexMatch >0, OriginalIndexMatch , newformula )

    I am assuming you know what the original formula was that you had


    click on the * Add Reputation if this was useful or entertaining.

+ 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. Index match offset to get subsequent index values in a column
    By Andrew_Step in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 09-06-2013, 02:55 PM
  2. Replies: 3
    Last Post: 05-02-2013, 01:31 AM
  3. [SOLVED] VBA for creating Index-Match every 2 rows where INDEX refer to a different column per row
    By bisaya789 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-22-2012, 03:46 AM
  4. Replies: 2
    Last Post: 06-06-2012, 10:59 PM
  5. Replies: 5
    Last Post: 02-29-2012, 08:51 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1