If cells contain matching info, copy cell next to it and put it in another sheet

[murrayjl03]

Hi all,

I have the following information in sheet1:

Col A | Col B
aaaaa | Leeds
bbbbb | Leeds
cccccc | London

And in sheet 2 i have

Col A | Col B
aaaa | 1234
cccc | 4567
bbbb | 2345

If cell A1 in in sheet 2, copy cell B1 into sheet 1 C1.

an example of the results would be:

Col A | Col B | Col C
aaaaa | Leeds | 1234
bbbbb | Leeds | 2345
cccccc | London | 4567

Please note* i cannot sort the order of sheet1.

Hope this makes sense and thanks in advanced!

 

[LloydFinancials]

For "bbbbb", why are the results pulling in "2345" it it shows as "bbbb" on Sheet 2 (only 4 "b"s)?