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

[hapham]

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}.

[hru · Accepted solution]

• 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.

[Steve]

For reference:

help.appsheet.com

List Dereference

Dereference the items of a list in bulk to produce a list of the resulting values.