Seriously, how do I use Excel.

[tomterp]

No, I've done that. What I want is that if I select something in A1, I want data from another worksheet to automatically fill in for B1, C1, D1, ect

I've not seen that done but practically anything is possible in Excel if you have enough time.

[imref]

Okay, I want to be able to select something from a drop down menu and when I do, populate several cells with information from another worksheet that corresponds to the item in the drop down menu. Is it possible to do this without having an extensive formula in each cell I want to change?

It's not terribly difficult.  You have to put a validated list of data in the cell with the drop down. (Data/Validation from the menu).  Say, A,B,C as your possible choices.

Then somewhere (another sheet?) you build your response table:

Sheet "test"
A  10
B  20
C  30

(in the above A,B,C are your drop-down choices)

Then in the cells where you want to place the data that corresponds with the dropdown choice, you enter a VLOOKUP formula to find the number that corresponds with each of the potential dropdown choices.  See http://office.microsoft.com/en-us/excel-help/vlookup-HP005209335.aspx for a tutorial/examples of VLOOKUP

[Slateman]

It's not terribly difficult.  You have to put a validated list of data in the cell with the drop down. (Data/Validation from the menu).  Say, A,B,C as your possible choices.

Then somewhere (another sheet?) you build your response table:

Sheet "test"
A  10
B  20
C  30

(in the above A,B,C are your drop-down choices)

Then in the cells where you want to place the data that corresponds with the dropdown choice, you enter a VLOOKUP formula to find the number that corresponds with each of the potential dropdown choices.  See http://office.microsoft.com/en-us/excel-help/vlookup-HP005209335.aspx for a tutorial/examples of VLOOKUP

Okay, I got it.

Now, is there a way to have all these forumlas on another page OR allow for custom information to be entered in to the cell if it doesn't match a drop down menu.

[comish4lif]

Okay, I got it.

Now, is there a way to have all these forumlas on another page OR allow for custom information to be entered in to the cell if it doesn't match a drop down menu.

What do you mean formula on a different page?

As far as adding stuff in addition to the dropdown, I don't think that's possible. To get a dropdown, you have to limit the values to a named range, or a predetermined list. Otherwise, Excel sees the rule as this: limit the value to the dropdown choices. or, you know, anything you want.

[Slateman]

How do you add words/letters after importing a number from a cell?

So if I want to take the number in cell A1 and put it in cell B5 and add "yards" after it, how do I do that?

[comish4lif]

In A1 type =b5&" yards"

The & allows you to concatenate a bunch of stuff together. In this, the value from B5 and some text.

[Dixon Ward]

B5=CONCATENATE(A1," ",$Q2)

where Q2 is a cell in which you've typed "yards"

[Dixon Ward]

In A1 type =b5&" yards"

The & allows you to concatenate a bunch of stuff together. In this, the value from B5 and some text.

oh, nice. i didn't know this trick

could also use B5=CONCATENATE(A1," ","yards")

[tomterp]

In A1 type =b5&" yards"

The & allows you to concatenate a bunch of stuff together. In this, the value from B5 and some text.

Good tip.  I use concatenate quite a bit but never knew the "&" shortcut.

[imref]

Okay, I got it.

Now, is there a way to have all these forumlas on another page OR allow for custom information to be entered in to the cell if it doesn't match a drop down menu.

you need to put the formulas in the cells where you want the results to appear, but you can but the data table on another sheet within a workbook.

[comish4lif]

I wish you could type a range into CONCATENATE, like =concatenate(a1:a5)

[imref]

I wish you could type a range into CONCATENATE, like =concatenate(a1:a5)

yeah, but you could enter each cell individually: =CONCATENATE(F7, G7, H7)

[welch]

Gadzooks, you are a superhero!

My thanks to you all!

As a result of your heroic efforts, I shall tell you all the fruits of my labor. When you look at the careers of 3,748 professional baseball hitters since 1871, only one single player with a significant # of games as a hitter (400+, I think) has more walks than strikeouts: ...pitcher Mickey Lolich?!?

(Another interesting result: there was a real ballplayer named Urban Shocker.)

Wait a minute!

Was that a typo? ("only one single player with a significant # of games as a hitter (400+, I think) has more walks than strikeouts"). It used to mark a bad hitter: more K's than walks. I'd be surprised to find a pitcher with 400 decisions who gave up more walks than K's...

Eddie Yost: 1600 walks, 900 strikeouts, about 18 seassons.

[Slateman]

Has to be. Ted Williams had 2021 walks and 709 strikeouts

[imref]

ugh, guess we need to recheck his formulas.

[GburgNatsFan]

The whole world is basing decision making on a buggy Excel.

ugh, guess we need to recheck his formulas.

[Slateman]

It took me a while, but I finally figured out the index/match function and hot to make it work. I can now plug in the data for any round of ammunition and get accurate ballistic and wind charts

[HalfSmokes]

Hopefully that isn't part if his fangraphs submission

[Slateman]

I'd definitely read if it were ...