Trying to lookup with two conditions for a price

[Suzannemlynch]

I have multiple models (9) which have various prices for over 100 options. Please help. I am trying to have a lookup with a if statement to find the correct price.
I am stuck - the array- range has 100 rows with 9 columns.

 

[Lewiy]

Does this help?:

Book3
	A	B	C	D	E	F	G	H
1		Model1	Model2	Model3	Model4
2	Option1	90	50	22	69		Option	Option3
3	Option2	87	45	44	84		Model	Model2
4	Option3	97	74	93	12		Price	74
5	Option4	5	86	55	48
Sheet2

 

[erock24]

=INDEX($C$1:$C$5,MATCH($A14&$B14,$A$1:$A$5&$B$1:$B$5,FALSE),1)

confirm with ctrl+shift+enter

c=column to return
a=criteria1
b=criteria2
(can have many criteria)
a1:a5 is where you would find criteria1
b1:b5 is where you would find criteria2
(all ranges need to be in the order you selected criteria)

 

[Suzannemlynch]

Thanks I will try it!

 

[Suzannemlynch]

Can you perform the same index function from one sheet to find on another?

 

[Suzannemlynch]

The result is always N/A#. I even copied Lewiy's data to my computer and same result?! What am I doing wrong?

 

[Suzannemlynch]

OK - the answer is slow down and watch the details!!!
I got it to work! I am doing the happy dance!!!

Thanks so much for your help!