How to find values ​​in an Excel list?

Question

excel

Hello!
The number from D must be found in G (or not found if it does not exist).
For example, the value 2019-0011 is in both columns. If you specify explicitly
= SEARCH (D5864; G5862) - it does a great job, returns the "9" character. those. there is a number.
But you need to search in the array. I specify =SEARCH( D5864
;$G$5855:$G$6017) - and it doesn't work. Works only if the search is on the same line.
VLOOKUP is a good formula, but it won’t work here. searches only for specific values, not for the words in the cell..
Any options?

Answer 1

I'll answer myself :))
=VLOOKUP("*"&D5856&"*";$G$5855:$G$8201;1;FALSE)