Lookup based on concatenated data in a cell

Hi Guys

I have a workbook which contains 2 worksheets 'Database' and 'Project'

On the database sheet 'First Name' and 'Surname' are in separate columns A & B

On the project sheet they are concatenated in column A 'Allocated to'

In column B I want to return a mobile number.

Not sure what formula to use here.

Help please

Maybe, put this on B2 and drag down:

=IFERROR(INDEX(Database!$C$2:$C$4,MATCH(1,INDEX((Database!$A$2:$A$4=LEFT(A2,FIND(" ",A2,1)-1))*(Database!$B$2:$B$4=TRIM(RIGHT(SUBSTITUTE(TRIM(A2)," ",REPT(" ",255)),255))),),0)),"")

Wow what a formula - not surprised I was having trouble with that one.
It works like a dream. Well done Azumi!
Thanks very much for the help.