Not sure if I need an IF/AND, match, vlookup…please help!

[Carl666s]

Hi,
I've been tasked with a doozy. I have two tabs.
The 'schedule' tab has Payroll refs in A2-A19 and Exam refs in B2-G2
The 'export' tab has Payroll refs in C1-Z1 and Exam refs in A2-A20 and whether they have passed (a P is shown) in range C2-Z20

I have to see if a Payroll ref has completed each exam and show that in the 'schedule' tab next to the relevant payroll number and exam ref. Not all of the Payroll nos are in the export tab which is why I need a formula (there will also be people added and removed over time so the formula needs to do checks to see if they are there)

My thinking was that I need 3 linked IF statements but I can't get that to work. Any ideas?

Schedule tab

Export tab

 

[Fluff]

Hi & welcome to MrExcel.
As you description does not match the images, this is based on the image.
In O8 dragged down & across

=IFNA(INDEX(export!$C$2:$Z$100,MATCH(O$5,export!$A$2:$A$100,0),MATCH($B8,export!$C$1:$Z$1,0)),"")

 

[Carl666s]

=IFNA(INDEX(export!$C$2:$Z$100,MATCH(O$5,export!$A$2:$A$100,0),MATCH($B8,export!$C$1:$Z$1,0)),"")

That worked perfectly, thank you. Been stuck on that for days

 

[Fluff]

You're welcome & thanks for the feedback.