Thread: Vlookup or Index / Match for multiple criteria and return a date value from cell

I'm trying to look at multiple criteria on one sheet and return the value (date) from that row. I'm having the hardest time for some reason. Basically, explained below and I've attached a spreadsheet too.

I want to know if A2=Column A in sharepoint tab and $b$1=Column C in sharepoint tab, return the value from Sharepoint tab Column F to Cell B2. Need this for all columns and rows.

All help would be greatly appreciated!

Assuming there is only 1 match...

=SUMPRODUCT((Sharepoint!$A$2:$A$112=$A2)*(Sharepoint!$C$2:$C$112=B$1),Sharepoint!$F$2:$F$112)

Here's what I did.
First, insert in Sharepoint an new column (I did it after C)
In the new column (D) in D2 =A2&C2 dragged down.

Then in StatusReport!B2
=IF(ISERROR(MATCH($A2&B$1, Sharepoint!$D$2:$D$112,0)),"Not Complete", VLOOKUP($A2&B$1,Sharepoint!$D$2:$G$112,4,FALSE))
dragged across and down.
Does that work for you?