Multiple references for Drop Down formula equation

[RodneyC]

I have this formula in cell E6

=IFNA(VLOOKUP($D$3,'Revenue Analysis'!$B$2:$Q$1201,4,FALSE),"")

1. This looks for the value shown at $D$3 in the Revenue Analysis tab somewhere between $B$2:$Q$1201. In reality, all of the data that could be shown in $D$3 is in column B.
2. I need a second criteria added to the formula. I need it to look at $D$6 and try to find it in the Revenue Analysis tab in $C$2:$Q$1201.
3. If the search finds BOTH the value in $D$3 and $D$6, it should report the value in that row for column D.

$D$3 pulls a value from a drop down menu.
$D$6 is a static value that shows up multiple places in column C on the Revenue Analysis tab.

Thank you in advance

 

[RasGhul]

maybe try, I think column 4 in your vlookup should be Column E on the Revenue tab;

=IFNA(INDEX('Revenue Analysis'!$E$2:$E$1201,MATCH($D$3&$D$6,INDEX('Revenue Analysis'!$B$2:$B$1201&'Revenue Analysis'!$C$2:$C$1201,),0)),"")

 

[Peter_SSs]

I think column 4 in your vlookup should be Column E on the Revenue tab;

I agree with that. My suggestion is

=INDEX(FILTER('Revenue Analysis'!$E$2:$E$1201,('Revenue Analysis'!$B$2:$B$1201=$D$3)*('Revenue Analysis'!$C$2:$C$1201=$D$6),""),1)

 

[Peter_SSs]

.. or a bit shorter like this

=LET(r,'Revenue Analysis'!$B$2:$E$1201,INDEX(FILTER(r,(INDEX(r,0,1)=$D$3)*(INDEX(r,0,2)=$D$6),{1,1,1,""}),1,4))

 

[RodneyC]

The solution offered by RasGuhl was the first in line. I tried it and it worked. THANK YOU both for offering help.