Multiple conditions in MATCH and INDEX functions

C

clanofmiller

Hi, I am too dumb to work this out on my own.

I have an array:

Type A Ver1 Price
Type A Ver2 Price
Type A Ver3 Price
Type B Ver1 Price
Type C Ver3 Price

What I need to do is to create a function, which would fill value
Price from Sheet2 into Sheet1 into similar form:

ConstantA
 
Top