INDEX/MATCH to retrieve several cells

Hi

I am using the following formula =INDEX({Source Sheet Range 1}, MATCH([Dev Resource]1, {Source Sheet Range 3}, 1)) to retrieve data from SourceSheet to MJ2 sheet.

The formula retrieves only one record when I need to retrieve all records associated with MJ.

Anybody ran into this issue?

Thanks

Xav..

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!