Find Replace items in list to targeted range Range=A:A, What=Col_x Replacement=Col_y

Hi Guys

Please see attached and example of what I'm trying to achieve

Is it possible to replace the values, in a specified range (column ref or heading no preference)
with the list contents of one column, replaced with the corresponding values of another column, row by row

ie look in column A
and check for presence of F1 and replace it with the value in G1,
then check for F2 and replace with G2,
then F3 to G3
...etc

The hurdle is this "looping" for me, although I recognise I could declare each and every row cell
Many thanks for all your help

Please Login or Register  to view this content.