Extract string values from one table to another table

[excelnovice2000]

Hi Experts
Can I get some help with a DAX function.

I have 2 tables (Table A and Table B) and I want to extract Table B values to Table A. I have attached a sample data file with desired result in red color.

Thanks for your help.

 

[Hui]

E8: =INDEX($H$8:$H$11,MATCH(D8,$G$8:$G$11,0))
Copy down

 

[excelnovice2000]

E8: =INDEX($H$8:$H$11,MATCH(D8,$G$8:$G$11,0))
Copy down

Thanks for your solution Hui. However I am using Power BI and looking for a DAX formula.

Thanks for taking your time to review my problem