Data selection

[yaparala]

sheet2 having data

sheet1:-
when i enter B1 cell is 121 or 122 or 123 then under name(a3),number(b3) fileds need to fill 121 data.

example.
B1 is 121
Name Number
1 a1
2 a2
3 a3
4 a4 like this.


Thanks for advance


sreenu

 

[Hui]

A3: =INDEX(Sheet2!$B$3:$G$7,ROW()-2,MATCH($B$1,Sheet2!$B$1:$G$1,0)+COLUMN()-1)
Copy across and down

 

[yaparala]

Hi Hui,

i got error is N/A.

 

[SirJB7]

Hi, yaparala!
I don't, and followed Hui's indications. Give a look at the uploaded file.
Regards!