Excel Match value_lookup asterisk syntax

[Jason]

=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

 

[Peo Sjoblom]

Try

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


Regards,

Peo Sjoblom