Data validation automatically show first item in list

[sumonrezadu]

Is there any way by which 1st cell of list will come automatically in data validation. For example in my attached sheet, If I select Dhaka_B, in F2 SELIM DEWAN will be shown automatically, then I choose name in the list at my own.

Thanks in advance.

Rezaul

[Pete_UK]

You can display the first name of the group in F2 using this formula:

=IFERROR(INDEX(A2:C2,MATCH(E2,ZONE,0)),"")

However, if you then choose a different name from the drop-down list, it will overwrite the formula, and the only way to reinstate it would be through Undo.

Hope this helps.

Pete

[sumonrezadu]

Thanks for your quick reply. Basically what I want is data validation in F2 where 1st cell will come automatically containing the available name of the list down. So that I can later select another name from the list (drop down in F2) at my own.

Ty