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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Multiple conditions in MATCH and INDEX functions 4
price ticket template 2
Index Match Max? 2
Trying to lookup based on a condition of two values 1
match row, then match column, then get header for that column? 1
INDEX MATCH AND ?? 2
trying to figure out a two way lookup to determine a value 5
Trouble with Array multiple return formula 4

Top