Is there a way to lookup each value in a list and return a list with the result of the lookup value?

Hi everybody!
Is there a way to look up each value in the list and return the list with the lookup value result?
I have a list like this: {ID1, ID2, ID3} and I want to loop through each value of the list then lookup that value to get another one. The expected result is a list of {Name of ID1, Name of ID2, Name of ID3}.

  • If your first list is an enumlist based type ref -lets call this as [IDs]

  • and the result list is on the same table with the [IDs] - lets call the result as [Names]

  • you can just have an app formula of [IDs][Names] which will give you the list of names.

4 Likes

For reference:

2 Likes