Multi-criteria lookup

[Jedi Master]

Hello Everyone! I have data created by a python script in a sheet. I am looking for help determining the correct formula to lookup the data in the table. The table looks as follows: Column 1 is employee name. The next 2 columns are a "Job Name (Column 2 has "2" after the same job name as previous column, and so on for the rest of the table through column EK. Row 2 in each column references Yes/No and a mileage value in each of the 2 job name columns.

I have the sheet where I am trying to lookup the table values:

I need to reference the job name (C13) and the employee name (C14) and retrieve the corresponding mileage value for that job for that person (D14) and the Yes/No value for that job for that person (E14). I am trying to use an Xlookup with &, but havent figured it out yet. Looking forward to any help with this. Thank you in advance!

 

[Asbestos_Jen]

This is what I came up with. I didn't put it into the same layout as your 2nd picture, since nothing there matched the list in the first picture.

=XLOOKUP(A18,$A$3:$A$14,XLOOKUP($B18&2,$B$1:$G$1,$B$3:$G$14))

Credit to Microsoft support page, example 5 XLOOKUP function - Microsoft Support

 

[Jedi Master]

Thank you so much!, this was the solve.

 

[Asbestos_Jen]

Glad to have helped, and thanks for the feedback.