Multiple ifs at once?

[Legacy 488112]

Hello,
I'm really confused with powerpoint, I basically want to create a table that will automatically assign the price depending on the country I select and the type of the product, I don't want to enter the price manually everytime and I don't really know what to do..

I have dropdowns for the country and the type but I have no clue how to do the IFs without there being 30 million ifs.. :/
I have another list with the countries and the type (I changed the values to something random) so lets say the Beer costs 20$ in the US (our cost being 10$) but in the NL it costs 10$ (our cost being 5$ there)

Book1 (version 1).xlsb
	A	B	C	D	E	F
5	ID	NAME	COUNTRY	QTY	TYPE	1 PCS PRICE
6	#01		USA	60	COKE	18,00 €
7	#02		USA		COKE
8	#03		USA		COKE
9	#04		USA		COKE
10	#05		USA		COKE
11	#06		USA		COKE
12	#07		USA		COKE
13	#08		USA		COKE
14	#09		USA		COKE
15	#10		USA		COKE
16	#11		USA		COKE
17	#12		USA		COKE
18	#13		USA		COKE
19	#14		USA		COKE
20	#15		USA		COKE
21	#16		USA		COKE
22	#17		USA		COKE
23	#18		USA		COKE
24	#19		USA		COKE
25	#20		USA		COKE
MAIN

Cells with Data Validation
Cell	Allow	Criteria
C6:C25	List	=INDIRECT("COUNTRY[COUNTRY]")
E6:E25	List	=INDIRECT("TYPE[TYPE]")

 

[ranman256]

if your gonna start nesting IF's, just build a function for much more readable code.

 

[Legacy 488112]

if your gonna start nesting IF's, just build a function for much more readable code.

And how do I do that?

 

[Legacy 488112]

I found the VBA editor but it will only let me put in 2 cells to have in the function, not 3 :/

 

[Legacy 488112]

Alright,
I literally paid someone for a solution so for those looking here:

=IFERROR(VLOOKUP($D7; Options!$C$7:$F1000;@ SWITCH(F7; "Snack"; 2; "Coke"; 3; "Beer"; 4); 0); 0)