Complex index match lookup

Ok I am going to try to describe this as easily as possible. I cant upload because I am at work and our network will not allow it.

I have a 3 tab document.

Tab one will be my main tab that has all the information that I need to see and monitor.
The tab is laid out like this...
Column A is where the formula will be, Column B is where a persons name will be IE Jane Doe.
The next tab is a table that contains The person and then their job tasks that are currently assigned to them the layout is...
Column A - Name. B - Job# (1), C- Job Assignment number (R050298737)
The Next Tab is a table that has Each job and the percentage in which it is completed. The layout is
A - Job Assignment number, B - schedule time, C- % completed.

This is where the formula comes in. I want a formula in (A) on the first tab to Match the name in (B) on the first tab to the name in (A) on the second tab and then use the Job assignment number in (C) in that second tab to get the % completed in (C) on the 3rd tab.

I don't know if this is possible or not or how someone could figure it out, that would be great any questions let me know.

You will need to put it into an array

{=INDEX(Sheet2!C:C,INDEX(1,('Sheet1'!B:B="Jane Doe")*('Sheet2'!A:A="Jane Doe"),0))}