just because a number is formated as a number doesn't mean it is one
try
{=INDEX('ALL DLV
SHPMTS'!$E$4:$E$1999,MATCH(1,COUNTIF(value(trim(B84)),"*"&value(trim(mso))&"*"),0))}
What are you trying to do with this equation? I haven't figured out the
logic of it yet.
"Alex" wrote:
> I am using the following array formula which seems to only work for most of
> the records. I don't use array formulas much and was wondering if there are
> some special consideration I need to know when using. The records that
> aren't working are on random rows. My mso range is correct. The only thing
> that is different about some of the records that aren't working is that the
> data in $E$4:$E$1999 is sometimes a #, but the cell is formatted as general.
> I appreciate any ideas you might have.
>
> {=INDEX('ALL DLV SHPMTS'!$E$4:$E$1999,MATCH(1,COUNTIF(B84,"*"&mso&"*"),0))}
Bookmarks