Dec 01 2020 06:54 PM
Dec 01 2020 10:16 PM
@Bharathgopi Excel can't differentiate between a company name that was incorrectly spelled and a correctly spelled company name that does not exist in a look-up table. In both cases, the company name is not found with #NA! as the result.
Now, your other question as I understand it is how to look-up only the company names that are part of a larger text string. In your example the names and dates are separated by a hyphen. Then you could do something like this:
Dec 02 2020 02:50 AM
Thank you for your reply.
The formula which you had mentioned doesn't work in my case because the table array values also contains the same format which is "Company name_dd.mm.yyyy".
I have added a snip to show an example how my lookup value looks and how my table array values look and also the result I expect to get using some Vlookup formula or with a combination of vlookup and other formulas.
Let me know if it is feasible.
Thanks & Regards
Bharath
Dec 03 2020 08:15 AM - edited Dec 03 2020 08:22 AM
@Bharathgopi Sorry. Can't answer. Your picture doesn't show the formula you used. Please upload the file.