Return multiple cell data with a VLOOKUP or INDEX MATCH

Options

Hi, I am trying to return the text within multiple cells based on criteria of an adjacent cell. In this example I want to return JOINED cell information from any the [News / Key Information / Highlights] column cells that matches 'NEMEA" in the [Region / Dept] column ( Ialso want to add in the criteria of being in the future but perhaps that's another separate question!). I've tried using INDEX MATCH and a VLOOKUP but it only returns the first cell of matching data. Can anyone help please?

=IFERROR("NEMEA" + CHAR(10) + INDEX([News / Key Activities / Highlights]:[News / Key Activities / Highlights], MATCH("NEMEA", [Region / Dept]:[Region / Dept], 0)), "")

=IFERROR(VLOOKUP("NEMEA", [Region / Dept]:AOB, 1), 0) + CHAR(10) + IFERROR(VLOOKUP("NEMEA", [Region / Dept]:AOB, 2), 0)

Best Answers

Answers

  • Lara Homewood
    Options

    That's amazing and works thank you!!! Silly question but is there a way to add +CHAR(10) between the Joins so there in a paragraph spacing between the joint cell info?

  • Lara Homewood
    Options

    YOU ARE WONDERFUL!! THANK YOU SO MUCH!

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!