Přejít k obsahu webu
Jiří Benedikt

Jiří Benedikt

Freelance innovator, educator: AI skills, Lean, +

  • Profile
  • Training
    • Training
    • Corporate training courses
      • AI for personal productivity
      • Lean Six Sigma
      • Design Thinking
      • Leading innovation
      • Adaptability
    • Skillshare Curses
  • Services
    • Services
    • In-house innovation incubator
    • AI adoption support
  • Resources
    • Resources
    • Design Thinking resources
    • Excel resources
    • LinkedIn
    • YouTube Channel
    • The Books I Recommend
  • CZ
  • Contact
  • 🔎

Excel: lookup multiple lines with a wildcard

Home > English > Free Resources > Free Excel Tutorials and resources > Excel: lookup multiple lines with a wildcard

This is a workaround I found:

The formula in the D3 cell is

=FILTER(A:B,ISNUMBER(FIND(D3,A:A)))

Jiří Benedikt, Používáme WordPress (v češtině). Ochrana soukromí
  • Profile
  • Training
  • Services
  • Resources
  • CZ
  • Contact
  • 🔎