Index and match without wildcard

[Xurun]

Hi,

I have a pretty straightforward job, match a value on a table and retrieve a value with the index function.

'°; '.; '<; '(; '+; '!; '&; ']; '$; '*; '); ';; '-; '/; 'À; 'Ç; ',; '%; '_; '>; '?; 'È; 'Ì; ':; '£; '§; ''; '=; '"; '[

but the data to match it's full of a wildcard ?,*;', etc so when I need to match exactly on the other table, it doesn't retrieve the wrong data.

I tried to put the tide in front of the * wildcard, but for some reason, it doesn't work.

what I need to do is to set the match command to see just plain text and not as wildcards.

Thank you.

 

[Alex Blakenburg]

Does this help at all ?

20220720 Wildcard Symbol Matches Xurun.xlsm
	A	B	C	D	E
1	Search Column	Code	Match result	Match Type	Formula
2
3	THIS A * TEST		3	Wildcard	=MATCH("*~**",A:A,0)
4			3	Wildcard	=MATCH("*~" & CHAR(42) &"*",A:A,0)
5
6	*	42	6	Exact	=MATCH("~*",A:A,0)
7			6	Exact	=MATCH("~" & CHAR(42),A:A,0)
8
9
10	test this value À content		10	Wildcard	=MATCH("*"&CHAR(192)&"*",A:A,0)
11	À	192	11	Exact	=MATCH(CHAR(192),A:A,0)
Sheet3

Cell Formulas
Range	Formula
C3	C3	=MATCH("*~**",A:A,0)
C4	C4	=MATCH("*~" & CHAR(42) &"*",A:A,0)
E3:E4,E10:E11,E6:E7	E3	=FORMULATEXT(C3)
B6,B11	B6	=CODE(A6)
C6	C6	=MATCH("~*",A:A,0)
C7	C7	=MATCH("~" & CHAR(42),A:A,0)
C10	C10	=MATCH("*"&CHAR(192)&"*",A:A,0)
C11	C11	=MATCH(CHAR(192),A:A,0)

 

[Xurun]

xl2bb doesnt work for me, i dont have time to figure it out why.

the formula is in my language but it's a simple index and match.

as you can see I suppose that the formula find a value based of the wildcard inside the cell.

I dont want that i want find the same 2 charts value on the table on the right.

thx

 

[Alex Blakenburg]

I am sorry but I don't understand what you are trying to say.
In column A you have '* are you searching for both characters
Does * only appear once in column E ? If that is the case formulas I gave you should work.

 

[Xurun]

I am sorry but I don't understand what you are trying to say.
In column A you have '* are you searching for both characters
Does * only appear once in column E ? If that is the case formulas I gave you should work.

Im sorry for my broken english.

in the end i solved my problem by converting the charts in number using the formula CODE()

Now instead of matching the symbols I am matching the numbers. Not great but its work as I want.

thank you.

 

[Alex Blakenburg]

Thanks for letting us know. Glad you found a solution.