Vlookup with If function on multiple criteria

[ssushant77]

Hi,

I have two database, let's say DBA and DBC.

Both the databases have invoice numbers as common while DBC has additional filed of Sale Date while DBA has additional field of Purchase Date.

I want to run vlookup on DBA by basing on the invoice number so that the following output is delivered:

Pick the matching invoices from DBC and wherever the invoice number of DBA matches with the invoice number of DBC, pick the number only if the purchase date in DBA is less than sale date in DBC.

How do I use the vlookup function to get the above result?

 

[theBardd]

Maybe this will work for you

=IFERROR(IF(VLOOKUP(INDEX(DBC,ROW(A1),1),DBA,2,FALSE)<INDEX(DBC,ROW(A1),2),N(INDEX(DBC,ROW(A1),1)),""),"")