how to retrieve all matches using vlookup

[nasir.atif123]

hi,i have one query. without using filter option how to solve it.i have a data in sheet1 like manager name, emp name, id , joining date.


in sheet2 i have only one manager name. so i want all employees details under that manager. like manager name, emp name, id , joining date in sheet2.


but if we use vlookup, it will retrieve first match only. so i want all matches in sheet2.


its a interview question. I have an interview next week.

 

[vasim]

http://office.microsoft.com/en-us/excel-help/how-to-look-up-a-value-in-a-list-and-return-multiple-corresponding-values-HA001226038.aspx