Forum Discussion

Emma95's avatar
Emma95
Regular Visitor
3 years ago

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 wildcards. Unfortunately I have not found a working solution so far. Can you help me?

 

Need Help

3 Replies

  • rajulshah's avatar
    rajulshah
    Resident Rockstar
    3 years ago

    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's avatar
      Emma95
      Regular Visitor
      3 years ago

      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's avatar
        rajulshah
        Resident Rockstar
        3 years ago

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