|
|
|
![]() |
|
|||||||
|
||||||||
![]() |
| Thread Tools | Rate Thread | Display Modes |
|
#16
|
||||
|
||||
|
Re: Scouting using Excel, please help
Quote:
|
|
#17
|
||||
|
||||
|
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 |
![]() |
| Thread Tools | |
| Display Modes | Rate This Thread |
|
|