If Checkbox Is Checked Then Return Content of Adjacent Cell

[jpulley]

I have inherited a document that was originally completed in Word and tasked with improvement. I'm hitting a wall trying to find the formula that will achieve the results I'm looking for.

Ideally (for example), I3 would check C3:C5 for TRUE and provide the information in D3:E5. To further complicate things, on the Veggies level there are more than one selection possible; some orders will only have one, others with have 3. In the final document, the Selection Summary will be in a separate sheet.

I'm afraid there will be a very simple solution that I'm completely overlooking. Any assistance would be greatly appreciated.

checklist-mrexcel.xlsm
	A	B	C	D	E	F	G	H	I	J
1								Selection Summary
2	Level	Checks		Part Number	Part Name			Level	Part Number	Part Name
3	Fruit		FALSE	1-123123	Apple			Fruit
4			FALSE	1-234234	Pear
5			FALSE	2-345345	Orange			Veggies
6			FALSE	0-123123	Fruit Box	Always Select with Fruit
7
8	Veggies		FALSE	3-456456	Peas
9			FALSE	3-567567	Celery			Spices
10			FALSE	3-678678	Broccoli
11			FALSE	4-123123	Corn
12			FALSE	4-234234	Kale
13			FALSE	0-234234	Veggie Box	Always Select with Veg
14
15	Spices		FALSE	5-123123	Mustard
16			FALSE	5-234234	Cinnamon
17			FALSE	5-345345	Clove
18			FALSE	5-456456	Cumin
19			FALSE	5-567567	Paprika
20			FALSE	5-678678	Allspice
21			FALSE	0-345345	Spice Box	Always Select with Spices
List

 

[dreid1011]

Maybe something like this:

Book1
	A	B	C	D	E	F	G	H	I	J
1								Selection Summary
2	Level	Checks		Part Number	Part Name			Level	Part Number	Part Name
3	Fruit		FALSE	1-123123	Apple			Fruit	2-345345	Orange
4			FALSE	1-234234	Pear
5			TRUE	2-345345	Orange			Veggies	3-567567	Celery
6			FALSE	0-123123	Fruit Box	Always Select with Fruit			4-123123	Corn
7									0-234234	Veggie Box
8	Veggies		FALSE	3-456456	Peas
9			TRUE	3-567567	Celery			Spices	5-234234	Cinnamon
10			FALSE	3-678678	Broccoli
11			TRUE	4-123123	Corn
12			FALSE	4-234234	Kale
13			TRUE	0-234234	Veggie Box	Always Select with Veg
14
15	Spices		FALSE	5-123123	Mustard
16			TRUE	5-234234	Cinnamon
17			FALSE	5-345345	Clove
18			FALSE	5-456456	Cumin
19			FALSE	5-567567	Paprika
20			FALSE	5-678678	Allspice
21			FALSE	0-345345	Spice Box	Always Select with Spices
Sheet1

Cell Formulas
Range	Formula
I3:J3	I3	=FILTER(D3:E6,C3:C6=TRUE,"")
I5:J7	I5	=FILTER(D8:E13,C8:C13=TRUE,"")
I9:J9	I9	=FILTER(D15:E21,C15:C21=TRUE,"")
Dynamic array formulas.

 

[jpulley]

Thank you so much! I can't tell you how much this has been plaguing me.

 

[dreid1011]

Thank you so much! I can't tell you how much this has been plaguing me.

You're welcome, and happy to help.