Vlookup with multiple conditons

[petrcz]

Hello,

could you please help me with the task below?
I need to find out, how much money is spent on advertising for specific landing page.
So, in first row column D of table1, there should be a value $10,50
In row 4, column d of table 1, there should be a value $15,00

The logic is this: if there is a value "cpc" in column A of table2 and if there is a value "google" in column B of table2 and the landing page in column C of table2 match with the landing page in column C of table 1, then put this value (column D of table2) to this cell..

table1

Medium	Source	LandinPage
cpc	google	/landing-page-1
cpc	bing	/landing-page-1
organic	google	/landing-page-1
cpc	google	/landing-page-2
(none)	direct	/landing-page-3

<tbody>
</tbody>

table2

Medium	Source	LandingPage	Cost
cpc	google	/landing-page-1	$ 10,50
cpc	bing	/landing-page-2	$ 11,00
cpc	google	/landing-page-2	$ 15,00

<tbody>
</tbody>

Thank you very much in advance for your assistance

 

[Santhosh26]

Hi,

If the both tables are in same sheet you can use the below formula

=IF(OR(A3=A11,B3=B11,C3=C11),D11,"NA")

The cell numbers can vary, u can choose wherever the values are.

If the table 2 in some other sheet you can use below formula

=IF(OR(A3=Sheet2!A2,B3=Sheet2!B2,C3=Sheet2!C2),Sheet2!D2,"NA")

Sheet number can be vary.

 

[petrcz]

Thank you!

 

[Aladin Akyurek]

A:C of Sheet1 houses table1; A:D of Sheet2 houses table2.

In D2 of Sheet1 control+shift+enter, not just enter:

=IFERROR(INDEX(Sheet2!$D$2:$D$4,MATCH($C2,IF(Sheet2!$A$2:$A$4=$A2,IF(Sheet2!$B$2:$B$4=$B2,Sheet2!$C$2:$C$4)),0)),"not found")

 

[petrcz]

Thank you Aladin

 

[Aladin Akyurek]

Thank you Aladin

You are welcome.