Forum Discussion

JoMont's avatar
JoMont
Frequent Visitor
10 months ago
Solved

How to replace text using a lookup table without duplicating text

I have the following table   Medical Registration Number Discipline Type Facility Type Start Date End Date Discipline Group MED1043 Primary Health ACCHS Primary Health 4/05/2023 21/...
Need Help
  • SundarRaj's avatar
    SundarRaj
    10 months ago

    Hi JoMont ,
    You can use the List.PositionOf function which shall give you the exact match according to the LookUps. I'll attach the imageşof the output and the file link below. Let me know if I have understood your query correctly and in case of any doubts as well.


    Thanks,

JoMont's avatar
JoMont
Frequent Visitor
10 months ago

Thank you, this has worked perfectly! Really appreciate your help.