Index formula help required

Hi all,

I need a help in index formula. I have attached the test file. Let me explain the problem.

Screen 1: This is the determining section. based on the value I have entered, the answers in C column, will be either YES or NO. SO we can have a sequence of answers like, No, No, No and Yes.
excel 1.JPG

Screen 2: Now I have a table with a mix answer sequence and have one Output column.
excel 2.JPG

Screen 3: Now, I want that based on the screen 1 answers, the function to match the sequence with screen 2 and pick up the value of Output column to the decision field.
excel 3.JPG

Can anyone help please??

Hi, thanks for your quick reply.

I want that, based on the screen 1 answers, the function to match the sequence with screen 2 and pick up the value of "Output" column to the "decision" field.

Perhaps if you put in a11 =B11&C11&D11&E11 and copy down then put the following in f2 =INDEX(F11:F26,MATCH(C2&C3&C4&C5,A11:A26,0))

Although it is not so clear what you want

Originally Posted by Glenn Kennedy

Use this array formula:

=INDEX($F$11:$F$26,MATCH(1,($B$11:$B$26=$C$2)*($C$11:$C$26=$C$3)*($D$11:$D$26=$C$4)*($E$11:$E$26=$C$5),0))

Array Formulae are a little different from ordinary formulae in that they MUST be confirmed by pressing CTRL+SHIFT+ENTER to activate the array, not just ENTER.

You will know the array is active when you see curly brackets { } - or "curly braces" for those of you in the USA, or "flower brackets" for those of you in India - appear around the outside of your formula. If you do not use CTRL+SHIFT+ENTER you will (almost always) get an error message or an incorrect answer. Press F2 on that cell and try again.

Don't type the curly brackets yourself - it won't work...

Your formula worked like Magic. Thanks a lot!