Automatically add value when value chosen from list

[Sacruzsa]

hello everyone,

I'm trying to create something in which when I select an item from the list in cell F, cell G automatically displays the value associated with the list in cell F
I tried via lookup but I don't get the desired result
can someone help me ?

thanks in advance

Accord.xlsx

[AliGW]

There are instructions at the top of the page explaining how to attach your sample workbook. Screenshots are of little practical use as we cannot manipulate them.

A good sample workbook has just 10-20 rows of representative data that has been desensitised. It also has expected results mocked up, worked examples where required, relevant cells highlighted and a few explanatory notes.