View Single Post
  #17   Spotlight this post!  
Unread 30-01-2017, 15:45
tr6scott's Avatar
tr6scott tr6scott is offline
Um, I smell Motor!
AKA: Scott McBride
FRC #2137 (TORC)
Team Role: Mentor
 
Join Date: Dec 2007
Rookie Year: 2005
Location: Oxford, MI
Posts: 538
tr6scott has a reputation beyond reputetr6scott has a reputation beyond reputetr6scott has a reputation beyond reputetr6scott has a reputation beyond reputetr6scott has a reputation beyond reputetr6scott has a reputation beyond reputetr6scott has a reputation beyond reputetr6scott has a reputation beyond reputetr6scott has a reputation beyond reputetr6scott has a reputation beyond reputetr6scott has a reputation beyond repute
Re: Scouting using Excel, please help

If you are learning, try to learn MATCH, and INDEX, as opposed to VLOOKUP.

There are times when you may need to look left to the key value, MATCH and INDEX allow you that flexibility. Also if you are building the data into a list your are going to "filter" by team number for review, you need to learn SUBTOTAL function too.

(match and index are non-volatile functions, so they process faster and force less re-calcs)


https://fiveminutelessons.com/learn-...nstead-vlookup
__________________
The sooner we get behind schedule, the more time we have to catch up.

Reply With Quote