[TABLE="width: 500"]
<tbody>[TR]
[TD]sheet 1
[/TD]
[TD][/TD]
[TD][/TD]
[TD]Sheet 2
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Name
[/TD]
[TD]Sparkline Here
[/TD]
[TD][/TD]
[TD]Name
[/TD]
[TD]J
[/TD]
[TD]F
[/TD]
[TD]M
[/TD]
[TD]A
[/TD]
[TD]M
[/TD]
[TD]J
[/TD]
[/TR]
[TR]
[TD]Bob
[/TD]
[TD][/TD]
[TD][/TD]
[TD]Jim
[/TD]
[TD]7
[/TD]
[TD]8
[/TD]
[TD]3
[/TD]
[TD]1
[/TD]
[TD]6
[/TD]
[TD]2
[/TD]
[/TR]
[TR]
[TD]Chris
[/TD]
[TD][/TD]
[TD][/TD]
[TD]Nick
[/TD]
[TD]3
[/TD]
[TD]9
[/TD]
[TD]6
[/TD]
[TD]2
[/TD]
[TD]0
[/TD]
[TD]5
[/TD]
[/TR]
[TR]
[TD]Jim
[/TD]
[TD][/TD]
[TD][/TD]
[TD]Bob
[/TD]
[TD]5
[/TD]
[TD]6
[/TD]
[TD]8
[/TD]
[TD]2
[/TD]
[TD]3
[/TD]
[TD]5
[/TD]
[/TR]
[TR]
[TD]Seth
[/TD]
[TD][/TD]
[TD][/TD]
[TD]Seth
[/TD]
[TD]2
[/TD]
[TD]0
[/TD]
[TD]6
[/TD]
[TD]8
[/TD]
[TD]2
[/TD]
[TD]7
[/TD]
[/TR]
[TR]
[TD]Nick
[/TD]
[TD][/TD]
[TD][/TD]
[TD]Chris
[/TD]
[TD]3
[/TD]
[TD]7
[/TD]
[TD]9
[/TD]
[TD]5
[/TD]
[TD]6
[/TD]
[TD]8
[/TD]
[/TR]
</tbody>[/TABLE]
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.
<tbody>[TR]
[TD]sheet 1
[/TD]
[TD][/TD]
[TD][/TD]
[TD]Sheet 2
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Name
[/TD]
[TD]Sparkline Here
[/TD]
[TD][/TD]
[TD]Name
[/TD]
[TD]J
[/TD]
[TD]F
[/TD]
[TD]M
[/TD]
[TD]A
[/TD]
[TD]M
[/TD]
[TD]J
[/TD]
[/TR]
[TR]
[TD]Bob
[/TD]
[TD][/TD]
[TD][/TD]
[TD]Jim
[/TD]
[TD]7
[/TD]
[TD]8
[/TD]
[TD]3
[/TD]
[TD]1
[/TD]
[TD]6
[/TD]
[TD]2
[/TD]
[/TR]
[TR]
[TD]Chris
[/TD]
[TD][/TD]
[TD][/TD]
[TD]Nick
[/TD]
[TD]3
[/TD]
[TD]9
[/TD]
[TD]6
[/TD]
[TD]2
[/TD]
[TD]0
[/TD]
[TD]5
[/TD]
[/TR]
[TR]
[TD]Jim
[/TD]
[TD][/TD]
[TD][/TD]
[TD]Bob
[/TD]
[TD]5
[/TD]
[TD]6
[/TD]
[TD]8
[/TD]
[TD]2
[/TD]
[TD]3
[/TD]
[TD]5
[/TD]
[/TR]
[TR]
[TD]Seth
[/TD]
[TD][/TD]
[TD][/TD]
[TD]Seth
[/TD]
[TD]2
[/TD]
[TD]0
[/TD]
[TD]6
[/TD]
[TD]8
[/TD]
[TD]2
[/TD]
[TD]7
[/TD]
[/TR]
[TR]
[TD]Nick
[/TD]
[TD][/TD]
[TD][/TD]
[TD]Chris
[/TD]
[TD]3
[/TD]
[TD]7
[/TD]
[TD]9
[/TD]
[TD]5
[/TD]
[TD]6
[/TD]
[TD]8
[/TD]
[/TR]
</tbody>[/TABLE]
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.