Ask Your Question
0

=MATCH confuses "AV." with "AVV"

asked 2018-02-22 22:35:53 +0200

jamesb gravatar image

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.

edit retag flag offensive close merge delete

Comments

2

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

Mike Kaganski gravatar imageMike Kaganski ( 2018-02-22 22:44:09 +0200 )edit

1 Answer

Sort by » oldest newest most voted
0

answered 2018-02-22 23:27:28 +0200

jamesb gravatar image

updated 2018-02-22 23:34:53 +0200

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!

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2018-02-22 22:35:53 +0200

Seen: 50 times

Last updated: Feb 22 '18