Data mapping one sheet to another

Hi Friends,

I have a workbook containing 3 worksheet Countries, Country Code, Country Name respectively. The worksheet countrries contains list of country code and country names. The worksheet "country code" range H10 contains country code. If the range H10 contans country code as IN and it should display as India in cell of D5 in "country name" sheet. The values should from the "countries" worksheet.

ex: if cell h10 in the "country code" sheet contains the value USA it should display as "United States of America" in the cell D5 in the "country name" sheet.


Please find attached workbook for your reference and also find code below which I was wrote.

Sub TestDict2()
        Dim i As Integer
    Dim dict As New Dictionary, vARray() As Variant
    i = 1
    Do Until IsEmpty(Cells(i, 1))
    dict.Add Cells(i, 1).Value, Cells(i, 2).Value
    
Debug.Print Cells(i, 1).Value, Cells(i, 2).Value
i = i + 1
  Loop
End Sub

Please kindly provide me the solution.

Thanks & Regards
Ramesh