Hi there-

I'm trying to do a vlookup and trying to find a text string that is not an
exact match.

For example, my current formula is:
=VLOOKUP("laptop*", $B:$C,2,FALSE)

and if it matches any text with "laptop", e.g. "Sony laptop" in it, it
returns the second column corresponding cell.

Also, intead of writing out the text "laptop" I want to reference a cell
where the text is. So I want to do something like:

=VLOOKUP(D1*, $B:$C,2,FALSE)

But I get an error warning. Can anyone shed some light?

Thanks!