Yes you can use wildcard in a vlookup, but does it really matters, it will
only pick up the first occurrence of a match


=VLOOKUP("*"&D1&"*",Table,2,0)

use wildcards as an example


Regards,

Peo Sjoblom


"Alex" wrote:

The following are columns in worksheetA:

TrkCase Order
iou9876y7
p0987ewuu


The following are column in worksheetB:

CaseNo Order
987 Apples
7ewuu Pears


In Worksheet A I need a formula (Orders column) that will look to see if any
CaseNo in WorksheetB matches the TrkCase in worksheetA and if it does, put
the cooresponding Order number from worksheetB in the Orders column in
worksheetA.

I'm using VLookup(A2,worksheetBA2:B2,2,False), which works fine if I don't
use wildcards, but how can I look for CaseNo anywhere inside TrkCase? Seems
like I should be using wildcards, but was having no luck. Thanks for your
help.