Switch formula but for multiple items in an array

Ask us anything How do I?
1

I am looking for the same functionality as the switch formula but rather for a single item I want this to apply to every item in my array.

Essentially I have an array with a list of codes.

A mapping of which linkes each code to a name.

And now I need a formula that translates my array of codes into a array of names.

1 Like
2

first filer your array of mappings with youy array of codes :
lookuparray(arrayOfCodes,mappingArray,"code")
Then, transform youy mapping array into an array of names :
rollup(lookuparray(arrayOfCodes,mappingArray,"code"),"name")

1 Like