need a formula or vba code to change cell value form another cell

Ex.

---> 0101 AAA 123 123 match <--- I want to write a value from another cell that is side of the matching cell without
AAA 124 *** writing any code in these cells?
---> 0101 AAA 123 123 match <---
AAA 124 ***

Welcome to the Forum. Can you provide a sample spreadsheet with some data showing the before macro layout, and the after macro layout you want to achieve? To attach a file, push the button with the paperclip (or scroll down to the Manage Attachments button), browse to the required file, and then push the Upload button.

CHECK AND FILL FUNCTION HELP.xlsx

im trying to attach a sample file hope it working or else if u could help me with the attachment.

thanks

In the blank cells in Column B, place this formula.

=INDEX(H4:H16,MATCH(C4,G4:G16,0))

Hope that helps.

thanks for your answer john, but if i place this formula in these cells then i cant make a search in excel becouse i could see the arcno(value) but you dont have the real value there i want to change the value in these cells without entring any code into them. hope there is some way to do it.

thanks