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.



Thanks!

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!