Finding a combination of numbers

[ganeshm]

hi excel users,

I have attached an excel file for finding out number combination.

which formula should i use to find out other combinations.

There is combin & permut in excel. Should i use any other formula along with this.

The sheet is without formula as i couldn't find the correct formula to apply.


Regards,
ganeshm

 

[Somendra Misra]

Hi GaneshM,

What value should appear for A-,I+ & Z?

Regards,

 

[ganeshm]

hi somendra,

the value need to appear in A+,I+ & Z = 25

where A-,I+ & Z need to be the result of combination of the given numbers.

regards,

 

[Debraj]

Try this..

In E12, use formula as ...

=INDEX($C$4:$E$6,MATCH(B14,$A$4:$A$6,0),INDEX(MATCH(C14&D14,$C$2:$E$2&$C$3:$E$3,0),0,0))

Hope it will work as per requirement..

 

[ganeshm]

the above formula when executed in cell E12 throws result #NA

regards,

 

[Debraj]

Did you found any difference between of "I-" and "I -" in C12 & C2 !!!!

 

[ganeshm]

i rectified and corrected the space between "I-" and "I -".

I think the "#NA" is because of no value in D14.

 

[Debraj]

So, can I assume it as solve..

 

[ganeshm]

i am working on it. Will definitely reply you once it is solved.