Matching with wildcards!

[1AG]

Good Morning all!
I am needing help with matching a cell using a wild card and finding match in a column with a wild card in another sheet and return Cell A of same row. This is the formula I began with
INDEX(A:A,MATCH("*"&B3&"*","*"&Sheet2!A:A&"*"),0) Thank you in advance!!

SHEET 1
A B
Name ID

Smith CO21493


SHEET 2

A
ID Name
CR-DO-FO-03-21493.com

 

[1AG]

SHEET 1
A	B
Name	ID
Smith	CO21493
SHEET 2
A
ID Name
CR-DO-FO-03-21493.com

 

[Jon Peltier]

As described in this tutorial, How to Use the Excel XMATCH Function, you can specify a wildcard match when using this new function.

Syntax
=XMATCH (lookup_value, lookup_array, [match_mode], [search_mode])
Arguments
lookup_value - The lookup value.
lookup_array - The array or range to search.
match_mode - [optional] 0 = exact match (default), -1 = exact match or next smallest, 1 = exact match or next larger, 2 = wildcard match.
search_mode - [optional] 1 = search from first (default), -1 = search from last, 2 = binary search ascending, -2 = binary search descending.