list one
col a col b
555* xyz
666?? abc


List two

5556
5557
66622

I would like a formula which would look up the items in list two, search
list one (which contains wildcard characters) and return the correct matching
item.

example:

I would like to look up 5556 in list a and return xyz and look up 66622 and
return abc.

I can easily do in reverse, but I can't figure out how to do in this
direction with the wildcards in the list a