Why is WILDCARD in lookup not working?

[Toki]

I am using splunk cloud.
I would like to use the lookup file to find out if there is an IP corresponding to the blacklist, but only 10.50.88.22 is hit.

[definition of lookup]
WILDCARD (IP)

[Contents of lookupfile]
IP
10.50.88.22
10.30.50.70

[Search statement]
|makeresults format=csv data="IP
10.50.88.220
10.50.88.22
10.50.88.2"
|lookup test.csv IP OUTPUT IP as list_IP
|where list_IP IN(IP)
|table IP list_IP

If it works correctly, I want the following two to hit.
10.50.88.220
10.50.88.22

Referencing past questions and changing the lookup definition to the following did not work.
WILDCARD (IP)

Is my search statement wrong?
Any advice would be greatly appreciated.

[bowesmana · Accepted solution]

Your lookup should contain an asterisk in the data where you want wildcard matching to work, e.g.

10.50.88.22*

but also you are using a lookup on the CSV itself, which does NOT support any wildcard lookup. You must use the definition name to perform the lookup, not the CSV file.

[Toki]

Thank you for your answer.
It is solved!