I want formula help

[aparvez007]

Hi All,

I need formula help to get desire output.
I have drop down in C3 and have 2 groups A & B if I select from drop down rest of the team name should appear from C6:H6.
Please check attached file.

Regards,
paVi

 

[NARAYANK991]

Hi ,

See if this is OK.

Narayan

 

[aparvez007]

Great Sir....
this is what I want. Thank you.