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.

[nested.if1@gmail.com]

Hi,

Please check if the attached is correct.

[shanuv]

I got exactly what I want.
Thank you so much.

[nested.if1@gmail.com]

You are welcome....!

If you are satisfied with the answer, please mark the thread as complete.
Also you can add reb by clicking on *