DashboardNovice
Member
I have a situation where I have a lookup value and I want to see if that value appears anywhere within a list (as a complete match or even a partial match). In the attached file, I am using the FIND( ) on a lookup value (41346.YR1.0002) and I want to see if that value appears anywhere within a list (column I).
For example, 41346.YR1.0002 does appear in I9 (as a complete match) and also in cells I10:I13 as a partial match which is ok.
My formula is in L7, but apparently the FIND( ) can't handle arrays.
Is there a function that can do this?
For example, 41346.YR1.0002 does appear in I9 (as a complete match) and also in cells I10:I13 as a partial match which is ok.
My formula is in L7, but apparently the FIND( ) can't handle arrays.
Is there a function that can do this?