I need to create a dropdown list but want to automatically include adjacent colums

[caremeals]

Can someone help me figure out how to do this

A B C D
1Entrees LS LC GF
2Swiss Steak x x x
3BBQ Chicken x x x


I WANT TO CREATE A DROPDOWN LIST BASED ON ITEMS IN A2:A3 NAMED ENTREES, BUT ON MY FORM I WANT TO ADD DATA FROM B,C,D TO MY SHEET?

HOW CAN I DO THIS SO THAT IT AUTOMATICALLY FILLS IF THERE IS INFORMATION IN THE CELLS

fOR EXAMPLE I CHOOSE SWISS STEAK FROM DROP DOWN LIST, THIS ITEM SHOWS IT IS AVAILABLE IN LS (LOW SODIUM) LC (LOW CARB) GF ( GLUTEN FREE) BECAUSE THERE IS A X IN THE COLUMN. I NEED THIS TO BE INCLUDED WHEN THE ITEM IS SELECTED IN THE DROP DOWN BOX AND INCLUDE INFORMATION ON THE SHEET. I JUST CANT SEEM TO FIGURE THIS OUT.

[Tony Valko]

One way...

Data Range

	A	B	C	D
1	Entrees	LS	LC	GF
2	Swiss Steak	x		x
3	BBQ Chicken	x	x	x
4	------	------	------	------
5
6
7
8
9
10		LS	LC	GF
11	Swiss Steak	x		x

A11 is your drop down list.

This formula entered in B11:

=T(INDEX($B$2:$D$3,MATCH($A11,$A$2:$A$3,0),COLUMNS($B11:B11)))

Copy across to D11