Excel Match value_lookup asterisk syntax

=INDEX(dest_zip,MATCH(I2,dest_name,0))

I want the I2 cell to be anything in the I2 cell and more. What is the
syntax for matching I2 and then wildcards after that.

Thanks

Try

MATCH("*"&I2&"*",your_range,0)


Regards,

Peo Sjoblom

"Jason" wrote:

> =INDEX(dest_zip,MATCH(I2,dest_name,0))
>
> I want the I2 cell to be anything in the I2 cell and more. What is the
> syntax for matching I2 and then wildcards after that.
>
> Thanks