Hi - I have two Text List fields in a table representing tags and their tag id's:
Tag List
Here is sample data tag1,tag2, tag3
Tag ID List
Here is sample data 8,10,14
There are three tags (tag1,tag2,tag3) and their Tag IDs are 8,10, and 14
I want to search Tag List to find a specific tag, and return the corresponding Tag ID for that Tag.
Is there any way to do this in a formula field?
Thanks
Jeff
------------------------------
Jeff Patrick
------------------------------