Thread: 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:

 =SUM(IF(ISNUMBER(FIND(" "&G$3&" "," "&'Q4 - Nov 1 to Dec 31 2011'!$C13:$P13&" ")),LEFT('Q4 - Nov 1 to Dec 31 2011'!$C13:$P13,FIND(" ",'Q4 - Nov 1 to Dec 31 2011'!$C13:$P13)-1)+0))

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...