Lookup Functions

I am trying to write a function to lookup and return the status of a part from another sheet. I need the function to match information from 2 cells: the project number and the part number and return the information in the status column.

Thanks in advance for your help!