Forum Discussion

Copper Contributor

May 29, 2023

Solved

VLOOKUP - not available

Hey. I have some codes, which I selled in some orders. I have them in cells with some additional text. I need to use =vlookup (in czech =svyhledat) to write to the codes, that they were sold in...

excel

Harun24HR
May 30, 2023
TheWeetek Use `XLOOKUP()` instead with wild card matching option.
=XLOOKUP("*"&A17&"*",A14,B14,,2)

Harun24HR

Bronze Contributor

May 30, 2023

TheWeetek Use `XLOOKUP()` instead with wild card matching option.

=XLOOKUP("*"&A17&"*",A14,B14,,2)

TheWeetek
Copper Contributor
Jun 04, 2023
Thanks, working for me.