Combining Data validation & Vlookup for generating a list

[Rajesh S]

Dear Team,

I am currently struck in one aspect. I have a master list of employees in different team. I would like to have the list of employees based on the value displayed in another cell where Data validation for dropdown is applied.

It would be great if anyone could help me out.

Regards

S Rajesh

 

[Sathish KV]

Hi,

Try the below formula in cells G24,

Note: Its an array formula so once the formula is entered press ctrl+shift+enter

=IF(ISERROR(INDEX($B$2:$D$29,SMALL(IF($D$2:$D$29=$H$21,ROW($D$2:$D$22)),ROW(1:1))-1,1)),"",INDEX($B$2:$D$29,SMALL(IF($D$2:$D$29=$H$21,ROW($D$2:$D$22)),ROW(1:1))-1,COLUMN(A1)))

 

[Rajesh S]

Thanks Sathish..It's working