Excel Question

[Dfjay9]

I've imported a table of stats alphabetically to sheet 1 (updates itself of course)

BUT. I'm having a hard time figuring out how to automatically move data to the next sheet. This is what I want to do, on sheet 2. I want to type "Air Force" and have all of airforces stats imported in specific columns. I've already set up the calculations I want done but its tedious sorting through 300 odd schools to find the one you need.

So I want to type "Air Force" or "providence" or something and have the stats show up. There is a way to do (I took an excel class years ago) but I just can't remember how.

Thanks

[Rediscoveryx]

Use filters on sheet 1 instead.

[TomG]

The easiest and most effective way to do this is a =VLOOKUP(). For example, let A1 be the cell where you type in "Air Force" or whatever. Then cell B1 next to it should contain the formula =VLOOKUP(A1, 'sheet1'!A1:Z9999, 5, FALSE). You'll need to read the documentation on VLOOKUP to understand the parameters.

As mentioned, a simpler option is to just use filters. A more complicated option is the use of PivotTables and the =GETPIVOTDATA() formula.

[williams22]

You could do it with macros as well. If you're having trouble send me a PM and I can help you out.

[roasthawg]

google vlookup or index/match.