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.
Bookmarks