List type function - dependant on drop down...

[McDan1el]

I have a drop down box which select a managers name - i want, depending on what manager is chosen for it then to populate the next 20 cells with their team names, from that i have vlookups to collate data.

I have a list in column A of agents names
I have a list in column B of that agents managers name

I know i could use a vlookup - but if i lock the fields it only displays the first results, how do you "skip" it on to the next person in the vlookup?

 

[Robert Mika]

Excel Workbook
	A	B	C	D	E
1	Agents name	Agents manager name
2	Noida	Hardeep		Pardeep	Kanpur
3	Gurgaon	Hardeep			Varanasi
4	Kanpur	Pardeep
5	Varanasi	Pardeep
6	Bangalore	Neeraj
7	Chennai	Neeraj
8	mama	Hardeep
Sheet3

D2 is your dropdown cell.
Extend your ranges accordingly.