Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

=MATCH confuses "AV." with "AVV"

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.