I’ve done a modest search but was not coming up with exactly what I was looking for. I have a list of numbers (rev-cloud workset IDs) that for each item in the list I want to search a second list (of sheet workset IDs) and I want to return the sheet name in the equivalent spot from the second list.
In excel:
vlookup(revCloudWorkSet, sheetWorkSets, sheetNames, true)
#syntax: vlookup(lookup_value, table_array, col_index_num, [range_lookup])
In picture:
would return:
E6.01
E6.01
E6.01
E9.01