Can vlookup two columns instead of one?

Hello,

Thanks for taking a peak at my problem.

I have columns entitled: CONTRACT_ID, PROJECT_CODE and PROGRAM_CODE

I have a filtered list on a different worksheet and I want to bring in the program code for a specific contract_id/project_code combination.

So I can't do a simple vlookup because one contract can have more than one program code, but there will only be one program code for a specific contract/project combination.

Can this be done with vlookup or should I be looking at some other functions?
Any help would be appreciated.

Thank you,

Adam Parker