OiO.lk Community platform!

Oio.lk is an excellent forum for developers, providing a wide range of resources, discussions, and support for those in the developer community. Join oio.lk today to connect with like-minded professionals, share insights, and stay updated on the latest trends and technologies in the development field.
  You need to log in or register to access the solved answers to this problem.
  • You have reached the maximum number of guest views allowed
  • Please register below to remove this limitation

Lookup Partial Match based on text in a defined column [closed]

  • Thread starter Thread starter Tanya Vander Vecht
  • Start date Start date

Tanya Vander Vecht

I am looking to pull the name of a customer and their contact information based on a partial match to the data drawn in from calendar entries to assess the last time that the person was contacted and use a list chart to display this. Please see link to the sample sheet that I have created.

You will see that my formulas are working for a couple of entries, but not all. I cannot seem to figure out what is making it not work for every entry.

Access Sample Sheet

I have tried FILTER combined with FIND, SEARCH, REGEXMATCH, and I have tried VLOOKUP which is what is in the sample sheet. All produce some results but not all. Changing FALSE to TRUE, produces results, but 98% incorrect results.

Continue reading...

Latest posts

Online statistics

Members online
Guests online
Total visitors