Hi I have 2 workbooks each with mutiple columns.

WRKBk1:
First Name (B) Surname(C) Email Address (E)

Wrkbk2 (reference source):
First Name (A) Surname (B) Email address (C)

I enter first and surname in to wrkbk1. I am looking for a function that
will match match the two colulmns in WRKBk1 with the data in WRKBK2 and then
extract the email address from 2 and put it into column (e) in workbook1