Vlookup cell containing "*"

[alombia]

Hi,
I'm having trouble using vlookup which involves "*" as part of the text I am searching for.
for example, my query data is:
[TABLE="width: 500"]
<tbody>[TR]
[TD][/TD]
[TD]A[/TD]
[TD]B[/TD]
[TD]C[/TD]
[TD]D[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]A*[/TD]
[TD]9[/TD]
[TD]A*[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]A[/TD]
[TD]8[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]B[/TD]
[TD]7[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD]C[/TD]
[TD]6[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]5[/TD]
[TD]D[/TD]
[TD]5[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]


In D1, I am writing VlookUP(C1,A1:B5,2,0). However, this returns 8, when it should be returning 9. What have I forgotten?

 

[FormR]

Hi, the * is being treated as a wild card and needs escaping with a ~ you can do that like this:

=VLOOKUP(SUBSTITUTE(C1,"*","~*"),A1:B5,2,0)