data for sparklines using vlookup

[Gtabtr1]

	A	B	C	D	E	F	G	H	I
1	id#	Mth 1	Mth 2	Mth 3	Mth 4	Mth 5	Mth 6	Mth 7	Mth 8
2	19	$100	$200	$150	$325	$175	$250	$200	$300
3	27	$150	$125	$175	$225	$300	$375	$400	$325
4	57	$75	$150	$275	$250	$325	$325	$400	$425

<tbody>
</tbody>

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.