all other cells data filled with single dropdown select

[yaparala]

Hi,
i have data(List) and i want report like (validation).

my query is:

in validation sheet:- when i am selecting A1,A2,A3,A4 IN ACCOUNT TYPE column in B2,B5,B8,B11 cell and other all relevant data for A1,A2,A3,A4 data should be filled automatically in other cells.

please find the attached sheet for more information.

 

[Sam Mathai Chacko]

What do you mean by other all relevant data? For example, if you select A1 in Cell B2, you need the cells A2:A4, C2:C4, D2:D4 to be filled automatically?

 

[yaparala]

Hi Sam,

yes.

 

[SirJB7]

Hi, yaparala!

If you can afford to use a helper column, E for example, you can try this:
E2: =SI(B2<>"";B2;E1) -----> in english: =IF(B2<>"",B2,E1)

So the formula for column A would be:
A2: =INDICE(list!$A$2:$A$12;COINCIDIR($E2;list!$B$2:$B$12;0)+CONTAR.SI($E$1:$E2;$E2)-1) -----> in english: =INDEX(list!$A$2:$A$12,MATCH($E2,list!$B$2:$B$12,0)+COUNTIF($E$1:$E2,$E2)-1)

Same thing for C & D columns adjusting the ranges accordingly.

Regards!