Forum Discussion

TheWeetek's avatar
TheWeetek
Copper Contributor
May 29, 2023

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

 

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

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

     

     

Resources