Sheet 2 &
Sheet 3 are in a single file.
Sheet 1 (In order) [large list]
Name Email A A@xyz //means A's email is A@xyz B B@xyz C C@xyz D D@xyz E E@xyz ... ...
Sheet 2 (In order) [large list]
Name Email F F@xyz G G@xyz //means G's email is G@xyz H H@xyz ... ...
Sheet 3 (Out of order) [smaller list, filtered (from another source)]
Name Email B A@xyz A D@xyz D B@xyz F H@xyz G F@xyz ... ...
Sheet 3 to be like:
Name Email B B@xyz A A@xyz D D@xyz F F@xyz G G@xyz ... ...
How do I map names to correct email-ids in
Note: There's no such case that a name is present but corresponding email-id is not and vice-versa.