insert data from other sheet using data validation(list)

[Ahmad Bazilin bin Azman]

Hi, I need help in this matter as we can see through my attachment exampleInvoice,
When we select one of company's name in the list, automatically the workbook will call in the data following the row.

I had tried searched for a whole week, but my bad i cant get any solution for it.
Please guide me.
T_T

 

[vijay.vizzu]

Please try the below formula in C4
=VLOOKUP($C$3,compAddress!$B$4:$F$6,ROW()-2,FALSE)

 

[Ahmad Bazilin bin Azman]

Thank you so much!!