Excel Forms Help

Myiagros

My GoogleFu is failing me with the proper keywords on this, I've only found the method for Access but it isn't very helpful for Excel.

I've thought of doing an Access Database in the past for stat keeping for my hockey league which I've looked for assistance with before. This time however I'm looking to make the initial score keeping easier, basically moving away from paper. Easiest way I can think of without having to program anything crazy is to use Forms inside Excel(which I'm currently using for tracking) that can be edited from a tablet, then saved/uploaded to OneDrive.

I'm currently stuck on how to have text boxes fill with data based on what is selected in a Combobox. Example:

A B C
Dec 1 Team1 Team4
Dec 2 Team2 Team5
Dec 3 Team3 Team6

Combobox contains the Date range selection, I want to select the date from the list and have the text boxes below it fill the Teams that are playing. Doing the date is easy but I'm missing the step on how to link the other columns to the date without having to do a huge IF statement(there are 90 games per year). I'm also planning on doing something similar for the goals/assists that links to other columns would be nice to use.

I'll probably run into more things I'll have questions about but this is a start.

Smrtnik

What you want is the lookup function (or one of its offshoots). You set up a table elsewhere on the sheet (or another sheet), then in the cell where you want to fill in the text box you were in the lookup function to refer to the pulldown vs that lookup table.

The Big Levinsky

Couldn't you just turn on the Auto-Filter for the date column? That would allow you to pick a date or dates from the filter drop down and see exactly what teams are playing.

Heffling

Assuming you have F6 as your date entry, you want:

Vlookup(F6,A1:C3,1) and Vlookup(F6,A1:C3,2) which will look up the values based on what is entered in F6 against column A, and the "1" and "2" tell it how many columns to the right of A to find the corresponding value.

Myiagros

Awesome, thanks guys, I'll try that out.