'Conditional' VLOOKUP possible?

Hi all,

I am looking for a way to use the VLOOKUP formula, while adding conditions in it so that 3 separate pieces of information need to correspond in order to return a value. I have attached a sheet to help explain what I am trying to do. It is very well possible that I should use a completely different formula, so please educate me!

The first table in the attached example shows FY2013 data. Each row represents a 'grant' with a project number, project title, recipient organisation, amount and the disease/product/R&D area it was for. This is information I already have for FY2013. The second table shows data for FY2014, where I have most of the information except for the disease/product/R&D area for each grant. To make my job easier, I want to check whether any of the FY2014 grants also appear in the FY2013 list, and then use that same disease/product/R&D area allocation for the FY2014 grant.

In order to identify whether the FY2014 grant is the same as one of those in the FY2013 list, the project number AND project title AND recipient organisation all need to be the same. This is where I run into trouble with a simple VLOOKUP, as this can only look at one of the values and check whether they are the same.

The last table in my example shows the result I am after. The 2 grants highlighted in orange were the exact same (same project number AND project title AND recipient organisation as in FY2013) and have therefore automatically filled in the disease/product/R&D area. The others returned an error (and I need to manually allocate the disease/product/R&D area).

I am new to posting questions on this forum and hope I was clear enough! Thank you very much for any help you can provide.

Warm regards,
Lis