Moving data from client report to my template


Hi - I'm importing client data to a template and I am using INDEX and MATCH formula

=INDEX({Crane Range 6}, MATCH([Contra Firm / Sponsor Acct #]@row, {Crane Range 2}, 0))

This works well for one column at a time.

I want to capture multiple columns at once so I'm not copying first name, middle name, last name, street address, city, state, and zip as individual formulas.

How can I capture multiple columns at once to match and populate my template? And thanks for your help!


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!