I have 2 separate workbooks and I need a function that will lookup an
attendee name in workbook #2 and return the corresponding confirmation number
into workbook #1. Here is an example:

Workbook #1 contains the following 3 columns

Confirmation # First Name Last Name
John Smith
Julie White
David Anderson

Workbook #2 contains the confirmation # I need in column 3. How can I do a
lookup formula that will return the corresponding confirmation #?

Thanks for your help.