VLOOKUP with multiple returns


I have two dropdown columns, building and building code. I want to select a building and have the building code auto-populated referencing to another sheet. I used a simple VLOOKUP [=VLOOKUP(Building@row, {Buildings and Infrastructure Range 1}, 2, true)] and it works when I select one building. However, it only returns one building code when multiple buildings are selected.

I am wondering if there is a way to return multiple building codes when multiple buildings are selected.



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!