Wildcard and LOOKUPVALUE problem

[Emma95]

Hello,

I have a table where I want to get Column_1, but not working:

I read about it and the problem is probably that the ID and SUBJECT are not on the same line and I should use wildcards. Unfortunately I have not found a working solution so far. Can you help me?

[rajulshah]

@Emma95 ,

Looks like you are using a single table here. LOOKUPVALUE usually is used when we want to have data from another table that is unrelated. Can you tell me what value do you want in Column_1?

[Emma95]

Yes, they are on one table. If the ID is found in the SUBJECT column, then write the Index, if not, it will be empty.
For example:
The first ID = H693569 in the SUBJECT line is emmamiraH693569bulla, so the first Column_1 = 2

[rajulshah]

@Emma95 , maybe, you can use CONTAINS here instead of LOOKUPVALUE. This function will search for the exact match.