Search Column A and B for string match and return value of column C

Good Morning Guys

In a macro that creates automatic e-mails I'm trying to take someone's name and then search for that persons details on another sheet and if it finds them, then it will return their e-mail address.

Here's where it gets slightly complicated. The persons name appears on sheet 'Transmittal Sheet' in Cell 'C12' and has their first name and last name in the same cell. When searching for them in sheet 'Contacts' Their first name is in column 'A' and their last name in column 'B' then their e-mail address is in column 'C'

Can anyone help me write some code that will split the name up and search for it in the contacts sheets?

Sorry this one is a pain in the bum, but I can't change the way the contacts sheet is set out.

Many Thanks in advance! Rep for any help as always!

R

It would help to attach a file with some sample data. To attach a file, push the button with the paperclip (or scroll down to the Manage Attachments button), browse to the required file, and then push the Upload button.

Will do bud,

Give me two mins, I have to strip the file of all the confidential data :P

Right a brief explanation of how this thing works.

PPU document Register - Enter Details then create sheet

Contacts - You'll have to enter some test data in here

Transmittal sheet - select data, document to send(data from PPU document register) & person(from contacts) to send it to.
Print to PDF - logs details from the transmittal letter in the transmittal register and also in the sheet created from ppu document register.

Also, for this workbook to work it should be in a folder called 'Document Control' which also has a sub folder called 'Document transmittals' which then has a folder in it called 'sent transmittals'

Sorry if all this seems a bit confusing, its quite difficult to explain all the different macros on this sheet briefly without boring you with my job!

MDR - SAMPLE.xlsm

Sorry your data in your sample is running me out of memory? I'm sure someone will be able to help you.

No worries J.D. Bump for any other help?

I've decided to pursue a different means of tackling what I'm doing, so I'm marking this thread as solved.