Forum Discussion
Wildcard and LOOKUPVALUE problem
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 wildca...
rajulshah
Resident Rockstar
Resident RockstarEmma95 ,
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?
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
