1.) Lookup column can return the value from another list, but can it work like excel vlookup where i can indicate col_index_num? For example, the column is looking up “staffID” column from another list, but after selection of “staffID”, it shows the “staffName” as column value.

2.) If new columns are added to a list template, how to reflect the updates in existing lists using this template? Or is it about content type? Please advice, thanks!

​1.) Lookup column can return the value from another list, but can it work like excel vlookup where i can indicate col_index_num? For example, the column is looking up “staffID” column from another list, but after selection of “staffID”, it shows the “staffName” as column value.2.) If new columns are added to a list template, how to reflect the updates in existing lists using this template? Or is it about content type? Please advice, thanks!  Read More

​