help formular in excel!!!

[Nguyen Anh Dung]

I have the picture below and have 2 sheets A and Sheet B. Please help formula get data from sheet B to sheet A.
Based on column name A: Thái Nguyên

Best regards,
Thanks all so much!!!
Dung

 

[etaf]

index(sheetb!C$2:C$1000, Match($A2,Sheetb!$A$2:$A$1000,0))

copy across and down

change the 1000 to the maximum rows expected

 

[Nguyen Anh Dung]

index(sheetb!C$2:C$1000, Match($A2,Sheetb!$A$2:$A$1000,0))

copy across and down

change the 1000 to the maximum rows expected

Thanks so much!!! i have function XLookup result ok!!!
Thanks!!!

 

[etaf]

you are welcome