Match numbers with attached symbol

[Khaldon]

I created a MATCH formula with an INDEX cells that contains same numbers with a different added symbol to it.
Example of cells content are 27# and 27* in the same column in sequence.

I noticed that the formula resulted in the number that matches 27# instead of the intended 27* corresponding number!!
Am I missing something, or is it an Excel issue, it does not distinguish symbols, in this case pound sign from asterisk and chosen the first matching number in column regardless of the attached symbol?

How can I fix this issue please and have the formula distinguish between 27# and 27*?

[XOR LX]

Hi,

How many other characters do you have apart from those two?

The *, if unqualified, is treated as a wildcard, so you would need something like (with e.g. 27* in C1 and your list in A1:A3):

=MATCH(SUBSTITUTE(C1,"*","~*"),A1:A3,0)

Regards

[[email protected]]

Use this.
=MATCH(A1,$A$1:$A$2)

Regards,
Suhas

[Khaldon]

Below is my formula, how it should be edited please?

=IF(ISNA(MATCH(B8,$A$43:$Z$43,0)),"",INDEX(A43:Z55,MATCH(A8,$A$43:$A$55,0),MATCH(B8,$A$43:$Z$43,0)))

[XOR LX]

Post a sample workbook so we can be clear.

Regards

[Khaldon]

It is not actually possible to post a sample due to the complexity of the workbook.


Regards

[XOR LX]

Then create a mocked-up, reduced file which at least illustrates your issue.

Regards

[Khaldon]

Thanks anyhow, I managed to change the 27* to 27(*) now the formula distinguish between 27# and 27(*) and resulted in the correct number.