Vlook up with a wild card option needed?

Hi,

This forumla did meet needs however some new data has appeared with additional info attached to it.
I need to add a wild card option on the AFX(...) part to include a /1,2,3, etc and am not clear how that could be done, thx.

=IF(COUNTIF(Odd!A5:A8091,"AFX0647E002167")>0, "167"
&CHAR(8)&VLOOKUP("AFX0647E002167",Odd!A5:O8091,4,FALSE)
&CHAR(8)&VLOOKUP("AFX0647E002167",Odd!A5:O8091,10,FALSE)
&CHAR(8)&VLOOKUP("AFX0647E002167",Odd!A5:O8091,14,FALSE)
&CHAR(8)&VLOOKUP("AFX0647E002167",Odd!A5:O8091,8,FALSE),"167"&CHAR(8)& "Open")

This searchable item AFX0647E002167 could now also be randomly presented in the searched field as
AFX0647E002167/1
AFX0647E002167/2
AFX0647E002167/3

Thanks

Thanks that worked...tired a bunch of things close to that but no that. I guess we will have to hire that co-student who wrote the code full time soon

Originally Posted by Tony Valko

Just add a wildcard to the end of the string like this:

"AFX0647E002167*"

You would need it in both the COUNTIF and VLOOKUP functions.

The answer is in your question.

Use a wildcard *

In your current formula, change every occurance of
"AFX0647E002167"
to
"AFX0647E002167*"