Return Multiple Look-up Values in a Contact List Field


We have a reference sheet which has a first column of Client ID followed by columns for Analyst Email and Manager Email (both are Contact List column type). On another sheet we have multiple columns and are trying to populate both the Analyst Email and the Manager Email values into one contact list field based upon the a Client ID look-up. Is this a nested vlook-up?

This formula is failing:

=VLOOKUP(VLOOKUP([Client ID #]2, {CSLS Teams by Account Range 1}, 4, false), {CSLS Teams by Account Range 1}, 6, false)


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!