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

You can create a helper column between the Product_Code and Program_Code columns that concatenates the Contract_ID and the Product_Code...then use that in your Vlookup.

E.g =Vlookup(A1&B1,Sheet2!C1:D100,2,0)

where A1&B1 are your input ID and Code and Sheet2!C1:C100 contain the concatenated items.