Forum Discussion
TheWeetek
May 29, 2023Copper Contributor
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 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