Results 1 to 6 of 6

Match formula syntax

Threaded View

  1. #1
    Forum Contributor
    Join Date
    04-18-2009
    Location
    USA
    MS-Off Ver
    Excel 2010
    Posts
    161

    Match formula syntax

    I have a match formula that i can't seem to get entered correctly. i am converting this from a lotus spreadsheet to an Excel spreadsheet. I attached a file so you can see the formula in action. i should be getting 14.2 in cell B3.

    If someone can look at the formula and see my problem here it is.

    Thanks,

    =IF(C44=0,0,INDEX(SETUP,(MATCH(+D89,'Setup Data'!B15:B44,0)-1)+1,(MATCH(D88,'Setup Data'!C14:F14,0)-1)+1))
    Attached Files Attached Files
    Last edited by Traymond; 01-11-2011 at 01:37 AM.

Thread Information

Users Browsing this Thread

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

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