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!
