Hi All,
So I can't get this to work, any help wold be very much appreciated from a excel newbie..
My puzzle I'm trying to find a solution is below -
If the values in column A Cell 'A13' of worksheet2 matches the values in column A Cell 'A19' of worksheet1 then copy the value of column B Cell 'B19' of worksheet1 to column C Cell "C13' in worksheet2.
So basically if a name "john doe" in worksheet2, matches a name in worksheet1 "john doe", copy the adjacent cell back to the row in worksheet2 where "john doe" is, and paste it in column C
Does anybody knows the code? Tried several things on Google, but I can't seem to find what I exactly need.
Workbook attached
Any help would be much appreciated
Thanks