VLOOKUP- Asterisk Problem

[dlove]

I am having trouble with my VLOOKUP formula finding an exact match in a table of values when the values contain an asterisk.

EX: Lookup value= WM22759/16-*2-9

The table may have tow values similar.

EX:

Row 1= WM22759/16-*02-9
Row 2= WM22759/16-*2-9

Even though the values are close, there are significant differences in the results. How can I get the formula to really find an exact match. In this case I would want it to return row 2 data, but it always returns row 1 because it is the first "closest" value it finds.

Help?

 

[Jubjab]

Try without the FALSE option in your lookup formula.

 

[VoG]

Try using WM22759/16-~*2-9 as the lookup value.

 

[dlove]

Wow. Both options work. This is my new favorite website. I appreciate the assistance and the speefy replies!