VLOOKUP - not available

[TheWeetek]

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 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 · Accepted solution]

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

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

 

[#3]

Thanks, working for me.