Results 1 to 14 of 14

help with date refrence

Threaded View

  1. #8
    Valued Forum Contributor
    Join Date
    04-09-2013
    Location
    Bangalore, India
    MS-Off Ver
    Excel 2010
    Posts
    391

    Re: help with date refrence

    See the file, You missed a comma highlighted in RED.

    =IFERROR(INDEX(Sheet1!$B$1:$AE$1,,SMALL(IF(INDEX(Sheet1!$B$2:$AE$3,MATCH('PC 1'!$B$1,Sheet1!$A$2:$A$3,0),)="OFF",COLUMN(Sheet1!$B$1:$AE$1)-COLUMN(Sheet1!$B$1)+1),ROWS($A$2:A9))),"")
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Refrence error
    By a.janmohammadi in forum Excel General
    Replies: 3
    Last Post: 03-10-2014, 02:50 PM
  2. refrence value
    By mak_pj in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 03-27-2013, 04:22 PM
  3. [SOLVED] cell refrence
    By jeeper74 in forum Excel General
    Replies: 4
    Last Post: 02-16-2013, 11:55 AM
  4. [SOLVED] Circular refrence necessary or is there a better way help
    By sakecat in forum Excel General
    Replies: 2
    Last Post: 05-02-2012, 03:27 PM
  5. Using one number to refrence another
    By pugsly8422 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 01-03-2005, 04:06 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1