wildcard function

[Dave]

Good afternoon,

Is there a way to have a wildcard search in excel. I know
I can use a "not exact" match but im not sure how to add
it to the following array function:
=INDEX(Data!$C$1:$C$3165,SMALL(IF(Data!
$A$1:$A$3165=$D$5,ROW(Data!$A$1:$A$3165)),ROW(2:2)))

In the data tab the info looks like this

header1 Header2 Header3
7040 1234 xxxxx
7040 2346 xxxxx
7030/7060 9999 xxxxx
7030/7060 8888 xxxxx

With my current function I can type 7040 (exact match) in
a cell and the function will goto the data tab, locate all
7040's in header1 and return to me the info in header2 and
header3.

Can I somehow search by 7030 and return to me everything
that has 7030 ie:7030/7060 and header 2 and 3. I Have
thousands of these and do not want to break up the ones
that are like 7030/7060 into their own rows.

any ideas?

 

[Frank Kabel]

Hi
try
=INDEX(Data!$C$1:$C$3165,SMALL(IF(ISNUMBER(FIND($D$4,Data!$A$1:$A$3165)
),ROW(Data!$A$1:$A$3165)),ROW(1:1)))