+ Reply to Thread
Results 1 to 1 of 1

Tweak array formula IF(ISNUMBER(FIND...

  1. #1
    Forum Contributor
    Join Date
    07-15-2011
    Location
    Whitby, Canada
    MS-Off Ver
    Excel 2010
    Posts
    121

    Tweak array formula IF(ISNUMBER(FIND...

    Hi,

    I have a formula that a great moderator came up with but I'm afraid it needs tweaking beyond my abilities. The formula is is a multisheet workbook - the formula will find a 'code' on the entry sheet and insert the associated number of hours into the tracking sheet (it is for tracking over-time hours). This was great until I came across a day when the person needed 2 different codes to be pulled from the entry cell (currently, the formula looks for the the code [shown in G3] in the range C13:P13)

    Here is the formula:

    Please Login or Register  to view this content.

    Since it is looking for a vaule based on the premise that there would only be 1 code in the entry cell, in the format of "##[space]CODE" I am suck...I can arrange for the data to be entered in any form, such as:

    10 STAT, 14 AC
    or
    10 STAT
    14 AC

    dummy workbook attached - thanks in advance...
    Attached Files Attached Files
    Last edited by Greed; 11-23-2011 at 11:31 AM. Reason: clarification

+ 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