Inserting extra code...

Guys. I hope the following is possible.

I have an excel sheet which contains the data in blue.

In another sheet I have the same data but with an extra code (red).

For my question I have put both in one sheet.

My problem is that I need to combine the extra code info in the sheet with the blue data. Both the blue column and first red column are identical.

How can I get this done? Somehow I have a feeling this is pretty easy, but then again I'm not sure how to do this. All help will be much appreciated! Thanks

Try

=Vlookup(F2,H:I,2,FALSE)

replace H:I with references to your "other" sheet.

and copy down

If you are satisfied with the solution(s) provided, please mark your thread as Solved.

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save