IndexMatch with multiple values as Match possible ?

[desmond_]

what I am trying to do is;
look up E11:E15 for "s" or "x" and return the value from A11:A15 and sum it up

I hope you can help
thanks in advance

see the example;
[TABLE="width: 100"]
<tbody>[TR]
[TD]..
[/TD]
[TD][/TD]
[TD]A
[/TD]
[TD]...
[/TD]
[TD]E
[/TD]
[TD]F
[/TD]
[TD]G
[/TD]
[TD]H
[/TD]
[/TR]
[TR]
[TD]10
[/TD]
[TD][/TD]
[TD]%
[/TD]
[TD]...
[/TD]
[TD]CW1
[/TD]
[TD]CW2
[/TD]
[TD]CW3
[/TD]
[TD]CW4
[/TD]
[/TR]
[TR]
[TD]11
[/TD]
[TD][/TD]
[TD]25%
[/TD]
[TD]...
[/TD]
[TD]s
[/TD]
[TD][/TD]
[TD]s
[/TD]
[TD]x
[/TD]
[/TR]
[TR]
[TD]13
[/TD]
[TD][/TD]
[TD]75%
[/TD]
[TD]...
[/TD]
[TD]s
[/TD]
[TD]x
[/TD]
[TD]x
[/TD]
[TD]x
[/TD]
[/TR]
[TR]
[TD]15
[/TD]
[TD][/TD]
[TD]10%
[/TD]
[TD]...
[/TD]
[TD][/TD]
[TD][/TD]
[TD]s
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]17
[/TD]
[TD][/TD]
[TD]Sum
[/TD]
[TD]...
[/TD]
[TD]=100%
[/TD]
[TD]=75%
[/TD]
[TD]=110%
[/TD]
[TD]=100%
[/TD]
[/TR]
</tbody>[/TABLE]

 

[FDibbins]

See if you can adapt this to your data...
[Table="width:, class:grid"][tr][td] [/td][td]

A​

[/td][td]

B​

[/td][td]

C​

[/td][td]

D​

[/td][td]

E​

[/td][/tr]
[tr][td]

1​

[/td][td]Name[/td][td]ID[/td][td]Rank[/td][td][/td][td][/td][/tr]

[tr][td]

2​

[/td][td]David[/td][td]

1001​

[/td][td]

1​

[/td][td][/td][td]Steve[/td][/tr]

[tr][td]

3​

[/td][td]Richard[/td][td]

1002​

[/td][td]

1​

[/td][td][/td][td]Mark[/td][/tr]

[tr][td]

4​

[/td][td]Steve[/td][td]

1003​

[/td][td]

0​

[/td][td][/td][td]Taylor[/td][/tr]

[tr][td]

5​

[/td][td]Mark[/td][td]

1004​

[/td][td]

0​

[/td][td][/td][td][/td][/tr]

[tr][td]

6​

[/td][td]Leo[/td][td]

1005​

[/td][td]

1​

[/td][td][/td][td][/td][/tr]

[tr][td]

7​

[/td][td]Michael[/td][td]

1006​

[/td][td]

2​

[/td][td][/td][td][/td][/tr]

[tr][td]

8​

[/td][td]Rafael[/td][td]

1007​

[/td][td]

2​

[/td][td][/td][td][/td][/tr]

[tr][td]

9​

[/td][td]Smith[/td][td]

1008​

[/td][td]

2​

[/td][td][/td][td][/td][/tr]

[tr][td]

10​

[/td][td]Taylor[/td][td]

1009​

[/td][td]

0​

[/td][td][/td][td][/td][/tr]
[/table]
E2=IFERROR(INDEX($A:$A,SMALL(IF($C$2:$C$10=0,ROW($C$2:$C$10)),ROWS($A$1:A1))),"")
entered using CTRL SHIFT ENTER, not just enter
then copy down

 

[AhoyNC]

Try:
Copy formula across columns as needed.

Excel Workbook
	A	B	C	D	E	F	G	H
10	%	*	*	*	CW1	CW2	CW3	CW4
11	25%	*	*	*	s	*	s	x
12	75%	*	*	*	s	x	x	x
13	10%	*	*	*	*	*	s	*
14	Sum	*	*	*	100%	75%	110%	100%
Sheet

 

[desmond_]

thanks a lot !

 

[desmond_]

works well

thanks !

 

[AhoyNC]

You're welcome. Thanks for the feedback and welcome to the forum.