Match formula?

[bswitalski]

I have two tabs - one (Summary Tab) with a list of names that should complete a task and the other tab (Intro) has a list of names that have completed it. I am trying to match up the email addresses from the Summary Tab to determine if the person completed it the task from the Intro tab, and return the % value from another column within the Intro tab.

I have tried the Match formula, but have to missing something as the value returned is not accurate once a name is not found from the Intro tab. What is the best way to obtain the result I am looking for?

Basically I would like the Summary tab to reflect if the person has finished the task and if so return the % value. If the name is not found in the Intro tab, then the Summary tab should reflect N/A or blank. I have placed comments in the file to help.

Thanks

[JieJenn]

In B2 enter =IFERROR(VLOOKUP(A2,Intro!$A:$J,9,0),"") then scroll it down

[oeldere]

With index / match (see the green cells).

See the attached file.