Vlookup with multiple if conditions

[Mariyka1]

I need to be able to vlookup with two different conditions.
I have two different tabs:[GAP] and [DDA]


Vlookup by "Company Name" in [DDA] for revenue from [GAP] only if the column "Type" in [GAP] says "Deposit" and only if the "created date" in [GAP]
is less than the "created date" in [DDA]

Not sure if possible with a vlookup - or would I need an array formula?

Help with this is very much appreciated!

 

[schwiggiddy]

Have you tried prefacing your VLOOKUP with an if statement?

If(And(Type=Deposit, CreatedGAP < CreatedDDA),VLOOKUP(...),"N/A")

 

[Aladin Akyurek]

@Mariyka1

Let A2 of DDA house a company of interest.
Let B2 of DDA house a date of interest.

In C2 of DDA control+shift+enter, not just enter:

=INDEX(revenue,MATCH($A2,IF(type="Deposit",IF(createddate < $B2,company)),0))

where revenue, type, createddate, and company are the relevan ranges in GAP.