Is There A Variant Formula?! Anyone ? :).

[JackNeedsHelp]

Hi,

Is there a formula where I can say 'If' such such matches then give me all the variants in another column.

For example how would I get a list of all the variants in the product category column for Dresses. I will then what to do sumifs from this.

Category Product Category
Dresses Maxi
Dresses Midi
Dresses Midi
Dresses Maxi
Dresses Short
Dresses Maxi
Tops Crop
Tops T Shirt
Tops Jumper
Tops Crop
Tops Jumper
Tops T Shirt
Tops T Shirt
Tops Crop

Thank you .

[Tony Valko]

Is this what you had in mind...

Data Range

	A	B	C	D	E
1	------	------	------	------	------
2	Dresses Maxi	6		Dresses	210
3	Dresses Midi	90		Tops	395
4	Dresses Midi	9
5	Dresses Maxi	52
6	Dresses Short	28
7	Dresses Maxi	25
8	Tops Crop	70
9	Tops T Shirt	96
10	Tops Jumper	6
11	Tops Crop	72
12	Tops Jumper	4
13	Tops T Shirt	50
14	Tops T Shirt	79
15	Tops Crop	18

This formula entered in E2 and copied down:

=SUMIF(A$2:A$15,D2&"*",B$2:B$15)

[oeldere]

with a couple of helpcells and index / match.

see the attached file (the green cells).