data for sparklines using vlookup

[Gtabtr1]

[TABLE="width: 500"]
<tbody>[TR]
[TD][/TD]
[TD]A
[/TD]
[TD]B
[/TD]
[TD]C
[/TD]
[TD]D
[/TD]
[TD]E[/TD]
[TD]F[/TD]
[TD]G[/TD]
[TD]H[/TD]
[TD]I
[/TD]
[/TR]
[TR]
[TD]1
[/TD]
[TD]id#
[/TD]
[TD]Mth 1
[/TD]
[TD]Mth 2
[/TD]
[TD]Mth 3
[/TD]
[TD]Mth 4
[/TD]
[TD]Mth 5
[/TD]
[TD]Mth 6
[/TD]
[TD]Mth 7
[/TD]
[TD]Mth 8
[/TD]
[/TR]
[TR]
[TD]2
[/TD]
[TD]19
[/TD]
[TD]$100
[/TD]
[TD]$200
[/TD]
[TD]$150
[/TD]
[TD]$325
[/TD]
[TD]$175
[/TD]
[TD]$250
[/TD]
[TD]$200
[/TD]
[TD]$300
[/TD]
[/TR]
[TR]
[TD]3
[/TD]
[TD]27
[/TD]
[TD]$150
[/TD]
[TD]$125
[/TD]
[TD]$175
[/TD]
[TD]$225
[/TD]
[TD]$300
[/TD]
[TD]$375
[/TD]
[TD]$400
[/TD]
[TD]$325
[/TD]
[/TR]
[TR]
[TD]4
[/TD]
[TD]57
[/TD]
[TD]$75
[/TD]
[TD]$150
[/TD]
[TD]$275
[/TD]
[TD]$250
[/TD]
[TD]$325
[/TD]
[TD]$325
[/TD]
[TD]$400
[/TD]
[TD]$425
[/TD]
[/TR]
</tbody>[/TABLE]
Not sure how to accomplish this but I need to lookup an ID # that is on sheet 1 and use the data on sheet 2 that is in that row as the data for the sparkline which will be on sheet 1. For example, the table above is on sheet 2.

On sheet one I look up ID# "27" I need the sparkline to use the values "150,125,175,225,300,375,400,325". This table is just an example. the real source data is 14 columns wide and almost 12,000 rows. And I need to create sparklines for all 12,000 rows.

Help.

 

[Johnny Thunder]

This sounds super basic?

If your Sheet 1 has an ID column and its blank and you want the values from Sheet 2 a basic Vlookup could get this done.

On your sheet 1 column B = VLOOKUP(A2,Sheet2!A$2:N$12000, 2,0)
On your sheet 1 column C = VLOOKUP(A2,Sheet2!A$2:N$12000, 3,0)
On your sheet 1 column D = VLOOKUP(A2,Sheet2!A$2:N$12000, 4,0)


Am I missing something?

 

[Gtabtr1]

Sorry for not being more clear. The sparkline in is a single cell on sheet 1. I need a formula that finds an id # and then uses the values from that row (B - I for example) to create a sparkline in a single cell.