How to Concatenate multiple cells into a single cell within a VLOOKUP formula?

edited 12/09/19 in Formulas and Functions

I've created a VLOOKUP formula to pull in data from a source smartsheet, into a 'staging' smartsheet but, if more than one row match the criteria, only the first row entered in the source smartsheet get entered into the cell on the 'staging' smartsheet.

For instance, I'm looking for entries on the source smartsheet that meet a specific 'week-ending date' but, if the source smartsheet has multiple rows meeting the 'week-ending date' criteria, only the first row entered will be pulled into the 'staging' smartsheet. In my case, I would like to have the contents of all cells matching the criteria pulled into the single cell on the 'staging' smartsheet. I've looked at the JOIN and "+" functionality but can't figure out if/how to incorporate them in the VLOOKUP formula, since the content of the multiple rows in the source smartsheet is variable.

Can anyone help?




Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!