+ Reply to Thread
Results 1 to 2 of 2

HELP I need find to get an exact match. When it searches for "1" it counts 11, 21, 1 etc

  1. #1
    Registered User
    Join Date
    11-15-2012
    Location
    Flint, Mi
    MS-Off Ver
    Excel 2003
    Posts
    2

    HELP I need find to get an exact match. When it searches for "1" it counts 11, 21, 1 etc

    HELP I need find to get an exact match. When it searches for "1" it counts 11, 21, 1 etc

    here is my formula

    =IF(ISERROR(INDEX(APPROVED!$A$3:$A$1002,SMALL(IF(ISNUMBER((FIND(G$4,APPROVED!$D$3:$Q$1002))*(FIND($H$1,APPROVED!$C$3:$C$1002))),ROW($C$3:$C$1002)-MIN(ROW($C$3:$C$1002))+1,""),ROW(G1)))),"",INDEX(APPROVED!$A$3:$A$1002,SMALL(IF(ISNUMBER((FIND(G$4,APPROVED!$D$3:$Q$1002))*(FIND($H$1,APPROVED!$C$3:$C$1002))),ROW($C$3:$C$1002)-MIN(ROW($C$3:$C$1002))+1,""),ROW(G1))))
    Attached Files Attached Files

  2. #2
    Registered User
    Join Date
    11-15-2012
    Location
    Flint, Mi
    MS-Off Ver
    Excel 2003
    Posts
    2

    Re: HELP I need find to get an exact match. When it searches for "1" it counts 11, 21, 1

    Basically I need to populate a calendar from a list. So Basically a user would fill out the approved worksheet and then corresponding month worksheet would populate the days. It works all for the fact that if they requested the 21 and 22 it shows up on the 21 and 22 but also ends up on the 1 and 2.

    HElp, Please and Thank you!

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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