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