• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Match: How/where do you use a wildcard [*/?] in the formula?

Hi


I'm using Index and match to retireve data from another workbook. It works great except for one cell where the formatting may be slightly different (but not to the naked eye). I've read that match can include wildcard cahracters - ? or * in the lookUp part.


My question is how are these, and where are these included within the formula? I keep getting a message box telling me it's not a valid formula everytime I try to enter it?


Code:
Match($A37,$A$11:$A$37,0)


Many thanks

Michael
 
Michael

Have you tried something like

Code:
=INDEX(A$1:A$10,MATCH("*"&C1&"*",A$1:A$10,0))


Adjust for Sheets and Ranges accordingly
 
Back
Top