Please I have a need for a code to match 2 different fields against another.
Below is the sample data. The codes and names form unique ID and need to be matched together. Where match is obtained, the Reg. No is copied to sheet.

Sheet 1
Code Name
001 paul
003 saint
004 peter
=============

Sheet 2
Code Name Reg. No.
003 paul er4556
001 paul ty6550
004 peter hg6633
003 saint lp5566
005 cain lk2255


See sample result below.
Sample Result
=============
Sheet 1
Code Name Reg.No.
001 paul ty6550
003 saint lp5566
004 peter hg6633