I need to write a formula that looks up a specific number (building number)
from a work sheet that has the specific number (building number) and returns
the corresponding name. My problem is that work sheet has multiple same
building number and can not get it to populate the all the names for that
building. Can any one help?