New Member Needs Help with a Lookup Function

[donnamc]

Hello (please forgive me if this is a repeat or stupid question) - I'm using excel 2010 and trying to complete a multitab worksheet. On the first tab the user will select a location from a drop down list. Based on that selection associated employees at that location should populate a second tab. The lookup data for all employees are found on a third tab. I have successfully used the =VLOOKUP($B$1,Employees!$A$2:$J$957,3,FALSE) to return the first matching employee, but am not sure how to copy the formula to move down the lookup list and return all other employees which match. Perhaps the vlookup function is not the most efficient choice? I'm open to any suggestions.

thanks, Donna

[Ace_XL]

Remove the absolute referncing with B1 and copy down.

hence,
=VLOOKUP($B1,Employees!$A$2:$J$957,3,FALSE) (column remains constant, rows change, can copy down and across)