ExcelBanter - Excel Match value_lookup asterisk syntax

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Excel Match value_lookup asterisk syntax (https://www.excelbanter.com/excel-worksheet-functions/27597-excel-match-value_lookup-asterisk-syntax.html)

Jason

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

Peo Sjoblom

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

All times are GMT +1. The time now is 10:07 AM.