VLOOKUP - not available

Copper Contributor


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 order 20230387, but its not working.


that one cell, which is "NENI K DISPOZICI" its "Not available" in english.

normally the command works, when I write it as






you might see, that when I write it just like this, it works (without the text), so I guess, error is in the "*"&A16&"*" ; but I don't know, how to write it.






any help? thanks


2 Replies
best response confirmed by TheWeetek (Copper Contributor)

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




Thanks, working for me.