sheet 1 | Sheet 2 | ||||||||
Name | Sparkline Here | Name | J | F | M | A | M | J | |
Bob | Jim | 7 | 8 | 3 | 1 | 6 | 2 | ||
Chris | Nick | 3 | 9 | 6 | 2 | 0 | 5 | ||
Jim | Bob | 5 | 6 | 8 | 2 | 3 | 5 | ||
Seth | Seth | 2 | 0 | 6 | 8 | 2 | 7 | ||
Nick | Chris | 3 | 7 | 9 | 5 | 6 | 8 |
<tbody>
</tbody>
I have a list of names on Sheet 1. I need to show monthly results using sparklines. The monthly results are on Sheet 2. I need to lookup the names from sheet 1 on a table on sheet 2. When I find the name I need to use the values in that row as the data for the sparkline. The table is just an example. Actual data has almost 12,000 names.