=MATCH confuses "AV." with "AVV"

[jamesb]

I’m using the following formula to look up a stock code and return it’s line number:

=MATCH(T(B12),HL_download.$B$1:$B$202,0)

Within the “HL_download” sheet there are a number of stock codes, and two are similar:

AVV

AV.

They are listed in the order above, i.e. AVV first.

The MATCH command fails to pick up “AV.”, always picking up “AVV”. The only way around this is to remove the “.” from “AV.”

Can anyone explain why?

Is there something I can to to avoid this problem?

Thanks.

[mikekaganski]

You have regular expressions enabled in formulas (see Options - LibreOffice Calc - Calculate; General Claculations group).

[jamesb]

Ah! Got it!

=MATCH(T(B19),T(HL_download.$B$1:$B$202),0)

It’s the missing second T() modifier that I need. Stupid me!

Thanks for helping me onto the right path!