Help Needed: Didnt know where to stick this
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]
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]