Need help to search one value and replace it with another from a big list

[shanuv]

Hi,

I have added one attachment. Iam explaining with reference to that.

I want to take the value one cell from column I for (eg:I5) , and search the same in column B:B and replace that value with 'VSS'.

Similarly, take one value from column H(eg:H5), and search it in column A:A and replace the value in adjacent cell B with the value in adjacent cell of H...ie value in I.
eg; search value in cell H5 (D12) in A:A and replace the value in adjacent cell B with value in I (AQ_SYS_X4HSS0_A_N).
Actual list is very big.

Please help.

Thanks in advance.