I would like to return all Addresses from another sheet where Column [Status] Matches a criteria

I would like to return all Addresses from another sheet where Column [Status] matches certain "text"

I have tried two formulas and at present they only return the first instance of the address, I have generated a report, however i now need to send this new sheet on to a team member to ensure the follow up work is carried out.

these are the formulas that I currently have.

Preferably I would like one line of code to incorporate multiple search criteria selected from a multiple dropdown box (if this is too difficult the formula with two search criteria will suffice)

=IFERROR(INDEX({Site Address}, MATCH("Advisory", {Status}, 0)), " ")

=INDEX(COLLECT({Site Address}, {Status}, CONTAINS("Statuatory", @cell)), 1)

Destination Sheet

Source Data Sheet


Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!