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:

	A	B	C	D
1	A*	9	A*
2	A	8
3	B	7
4	C	6
5	D	5

<tbody>
</tbody>

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)