Vlookup to find part of text string

I am trying to use VLookup in my macro to search for a part of a text string, so far I have
Range("C33").End(xlUp).Offset(1, 0).Select
ActiveCell.Formula = "=VLOOKUP(B169&" * ",b169:D185,2,FALSE)"
but keep getting a Type Mismatch error. Can anyone point out where I am going wrong?

Try it with double double-quotes around the asterisk, like this:

Please Login or Register  to view this content.

In future use CODE tags around any element of code (the # symbol in the editor).

Hope this helps.

Pete

Works, thank you :-)
Will add CODE tags next time too, thanks