I am trying to search an url from list of urls in Column A with xlookup (using wildcard), but it shows error "Did not find value ‘https://forums.pcsx2.net/*’ in XLOOKUP evaluation."
My formula is: xlookup(A10&"*",A2:A7,A2:A7)
I am attaching google sheet here for your reference.
Please guide me how to use wildcard match (*) in given example.
>Solution :
The xlookup function has an optional parameter to enable wildcard searches.
Try this: =xlookup(A10&"*",A2:A7,A2:A7,,2)