Help Needed: Didnt know where to stick this

[Squirrel]

OK Guys i'm after some excel help. I Couldn't find any sort of forum "tech-zone" so here will do. Shift it if need be. I'm not even sure if this is possible.

I have the top table from THIS page saved as a table in Excel on a tab named 'Pitchers', Is there a way I can have a table in another tab so that when I input a pitchers name down column A, it will automatically fill in a pitchers ERA (or whatever) in the column next to it?

I basically want it to automatically pull only the relevant info, I'm hoping there is a formula I can stick in there for it to find the information for me rather than bag loads of copying and pasting manually.

This is just an example to try and educate me, the table I have linked to is just a small one, the real one I want to use it on has nearly 600 entries in it. I'm sh*t at explaining these things but I hope someone gets the jisst of what I mean.

Cheers Dudes

[NOTE: The link is just to a baseball reference page, it aint no funny shit]

[Squirrel]

Please.....

Dont even know if its possible or not just want to know if i can save myself a boat load of copying/pasting every day. Alternatively does anyone know where I might be able to find help? I tried google but its all too jargon-ified for me

[Fiasco]

the way I have my excell baseball sheet set up I copy data from statfox into a page on there for each game I cap... I then have it linked in another spreadsheet (to link it you just go to page 2, pres "=" then go back to sheet 1 and click the cells you want to appear there... you can use simple math signs to create some formulas and all as well with this... this way they show up on your sheet when you enter the data on the other sheet

is this what you wanna know how to do?

I don't understand

[Mudcat]

My cat's breath smells like cat food.



No, sorry, I wish I could help but I just can't. I do a fair bit of Excel stuff but it is all pretty rudimentary. I am pretty boobish. I know that my computer is silver and black but that probably doesn't help either.

There are some people around here I think would know about this stuff. Maybe try the Think Tank if nothing happens here soon. Some brainy types in there.

[Willie Bee]

Squirrel, you want to somehow pull updates each day when Baseball-Reference makes them into an excel file, is that it? In other words, set up your excel sheet and then have it auto pull the updated data? I'm confused what you're asking exactly.

[Squirrel]

Ok, i'll try and explain it a tiny bit better. I have a table saved in excel exactly like the one above, only difference is its far bigger and contains every pitcher ever to get the ball for the Dbacks. It contains all the stats on that list.

What I want to do is, in a new tab on the sheet, have a smaller table with 2 columns. Down column A i want to be able to type the pitchers name and hopefully have some kind of formula in the 2nd column that will look for the pitchers name in the other sheet and just pull me his ERA automatically.

Ive been looking at VLOOKUP stuff but I dont really understand that since i'm still learning excel (which is part of this exercise).


If thats still not clear i'll use diagrams next time to try and explain better

[Fiasco]

I don't know how to do this, but essentially you want to set up some kind of command that when "name" is entered it automaticall puts era next to it?

I'd like to know that too.

until you do know you can just do ctrl+f and type the name on table one and then manually type or link it to your second sheet...

[Squirrel]

I don't know how to do this, but essentially you want to set up some kind of command that when "name" is entered it automaticall puts era next to it?

I'd like to know that too.

until you do know you can just do ctrl+f and type the name on table one and then manually type or link it to your second sheet...

YES!!! Pretty much exactly that, shame I couldnt explain it better!

[Pancho sanza]

=VLOOKUP(A1,Pitchers!C2:H7,6,0)

Where the pitchers name is in cell A1 , and the other tab (Pitchers) has the baseball ref page with the data starting in cell A1, and the first pitcher, Danny Haren, would be in cell C2

[Squirrel]

Thanks mate, I tried that and got a #NAME? error so i'm assuming there is some kind of formatting error. Gonna keep messing about with it. I'll get there in the end!

[LT Profits]

Put the names in the table in Alphabetical Order and then try Pancho's formula again.

[TomG]

The vlookup formula already given will work and is exactly what you are looking for (vlookup is the single best formula in Excel IMO). The formula is somewhat particular about formatting though. It gets confused easily between cells that are formatted as text versus numbers for example, even if the values are identical. Play around with it. You may need to do some mass re-formatting to get it to return an actual value. It will work though and will solve your problem.