Excel Match value_lookup asterisk syntax

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

=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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Index and Match 8
String Formula 8
Return value from a Two Variable Data Table with Dates 1
Grouping IF/AND/OR in a single formula 3
conditional formatting 1
Selecting Rows that meet criteria 1
HELP! I need to make an IF Statement comparing date/time fields.. 2
IF..THEN..ELSE 9

Back
Top