Help with Look-up Function!

[Candace@UH]

Hi all,
Here is the situation - I have names of people that attended a design
session in a excel spreadsheet, listed vertically. I have a separate excel
spreadsheet with the "time approver" for each employee in the hospital.

I need to match the attendee with the "time approver". There are about 2000
attendees and I need to look up their names from about 15,000 hospital
employees. The attendee list does not have middle initials but the "time
approver" list has middle initials.

None of my look up formulas and are if formulas are working - can you please
help so I dont have manually match names.

Thaks so much, any help would be appreciated.

 

[JLatham]

Take a look at this workbook I threw together to simulate your situation. It
has some added columns to break the names with middle intitials up and put
them back together as first + last only so that VLOOKUP() can work with them.
I'm not sure what all you need to do after doing the VLOOKUP(), but maybe
this will get you started so that you can continue on and finish your project.

Just save this file (Excel 2003 format) to your hard drive and peek in at it.
http://www.jlathamsite.com/uploads/forCandaceAtHU.xls