How about trying Data Filter AutoFilter, and selecting the building
number from the dropdown arrow on that column..........it will filter and
show you all those rows with that building number...........

hth
Vaya con Dios,
Chuck, CABGx3



"Jill_" wrote:

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?