match unique cutomer id and transaction with customer age

[Covaism]

I have 6500 customer with unique id's in one spreadsheet with the age of that customer. In another tab I have the same 6500 customers with unique and there 10000 transactions. I want to ad the ages to the transaction but I don't know how. I would like to to add column B from sheet 1 to column b in sheet 2 matching the customer id's in both Column A's. Please Help with the formula for Column B sheet 2.

sheet 1				Sheet 2
Column A	Column B			Column A	Column B	Column C
customer id	customer age			customer id		transaction
			Product A
			Product B
			Product C
			Product B
			Product B
			Product B
			Product A
			Product C
					Product C
					Product C
					Product A
					Product A
					Product A
					Product B

<colgroup><col style="width:48pt" width="64" span="9"> </colgroup><tbody>
[TD="width: 64"][TABLE="class: grid, width: 570"]
<colgroup><col span="2"><col span="2"><col span="3"></colgroup><tbody>[TR]

[TD="align: right"]22691[/TD]
[TD="align: right"]24[/TD]

[TD="align: right"]22691[/TD]

[TD="align: right"]23498[/TD]
[TD="align: right"]46[/TD]

[TD="align: right"]22691[/TD]

[TD="align: right"]23915[/TD]
[TD="align: right"]48[/TD]

[TD="align: right"]22691[/TD]

[TD="align: right"]30453[/TD]
[TD="align: right"]32[/TD]

[TD="align: right"]22691[/TD]

[TD="align: right"]30645[/TD]
[TD="align: right"]50[/TD]

[TD="align: right"]23498[/TD]

[TD="align: right"]31304[/TD]
[TD="align: right"]46[/TD]

[TD="align: right"]23915[/TD]

[TD="align: right"]33998[/TD]
[TD="align: right"]22[/TD]

[TD="align: right"]30453[/TD]

[TD="align: right"]34063[/TD]
[TD="align: right"]70[/TD]

[TD="align: right"]23915[/TD]

[TD="align: right"]23915[/TD]

[TD="align: right"]33998[/TD]

[TD="align: right"]30645[/TD]

[TD="align: right"]31304[/TD]

[TD="align: right"]33998[/TD]

[TD="align: right"]34063[/TD]

</tbody>

[/TD]
[TD="width: 64"][/TD]
[TD="width: 64"][/TD]
[TD="width: 64"][/TD]
[TD="width: 64"][/TD]
[TD="width: 64"][/TD]
[TD="width: 64"][/TD]
[TD="width: 64"][/TD]
[/TR]
[TR]
[TD][TABLE="width: 570"]
<colgroup><col span="2"><col span="2"><col span="3"></colgroup><tbody>[TR]
[TD] [/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"][/TD]
[TD="align: right"]

<colgroup><col style="mso-width-source:userset;mso-width-alt:3157; width:67pt" width="89" span="2"> <col style="width:48pt" width="64" span="2"> <col style="mso-width-source:userset;mso-width-alt:3128; width:66pt" width="88" span="3"> </colgroup><tbody>
[TD="class: xl67, width: 89"][/TD]
[TD="width: 64"][/TD]
[TD="width: 64"][/TD]
[TD="class: xl67, width: 88"][/TD]
[TD="class: xl67, width: 88"][/TD]
[TD="class: xl67, width: 88"][/TD]

[TD="class: xl67"][/TD]
[TD="class: xl67"][/TD]

[TD="class: xl67"][/TD]
[TD="class: xl67"][/TD]
[TD="class: xl67"][/TD]

[TD="class: xl67"][/TD]

[TD="class: xl67"][/TD]
[TD="class: xl67"][/TD]
[TD="class: xl67"][/TD]

[TD="class: xl68, align: right"][/TD]
[TD="class: xl68, align: right"][/TD]

[TD="class: xl68, align: right"][/TD]
[TD="class: xl68"][/TD]
[TD="class: xl67"][/TD]

[TD="class: xl68, align: right"][/TD]
[TD="class: xl68, align: right"][/TD]

[TD="class: xl68, align: right"][/TD]
[TD="class: xl68"][/TD]
[TD="class: xl67"][/TD]

[TD="class: xl68, align: right"][/TD]
[TD="class: xl68, align: right"][/TD]

[TD="class: xl68, align: right"][/TD]
[TD="class: xl68"][/TD]
[TD="class: xl67"][/TD]

[TD="class: xl68, align: right"][/TD]
[TD="class: xl68, align: right"][/TD]

[TD="class: xl68, align: right"][/TD]
[TD="class: xl68"][/TD]
[TD="class: xl67"][/TD]

[TD="class: xl68, align: right"][/TD]
[TD="class: xl68, align: right"][/TD]

[TD="class: xl68, align: right"][/TD]
[TD="class: xl68"][/TD]
[TD="class: xl67"][/TD]

[TD="class: xl68, align: right"][/TD]
[TD="class: xl68, align: right"][/TD]

[TD="class: xl68, align: right"][/TD]
[TD="class: xl68"][/TD]
[TD="class: xl67"][/TD]

[TD="class: xl68, align: right"][/TD]
[TD="class: xl68, align: right"][/TD]

[TD="class: xl68, align: right"][/TD]
[TD="class: xl68"][/TD]
[TD="class: xl67"][/TD]

[TD="class: xl68, align: right"][/TD]
[TD="class: xl68, align: right"][/TD]

[TD="class: xl68, align: right"][/TD]
[TD="class: xl68"][/TD]
[TD="class: xl67"][/TD]

[TD="class: xl68, align: right"][/TD]
[TD="class: xl68"][/TD]
[TD="class: xl67"][/TD]

[TD="class: xl68, align: right"][/TD]
[TD="class: xl68"][/TD]
[TD="class: xl67"][/TD]

[TD="class: xl68, align: right"][/TD]
[TD="class: xl68"][/TD]
[TD="class: xl67"][/TD]

[TD="class: xl68, align: right"][/TD]
[TD="class: xl68"][/TD]
[TD="class: xl67"][/TD]

[TD="class: xl68, align: right"][/TD]
[TD="class: xl68"][/TD]
[TD="class: xl67"][/TD]

[TD="class: xl68, align: right"][/TD]
[TD="class: xl68"][/TD]
[TD="class: xl67"][/TD]

</tbody>

[/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

 

[FDibbins]

Maybe this?
[Table="width:, class:grid"][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][/tr]
[tr][td]

1​

[/td][td]sheet 1[/td][td][/td][td][/td][td][/td][td]Sheet 2[/td][td][/td][td][/td][td][/td][/tr]

[tr][td]

2​

[/td][td]Column A[/td][td]Column B[/td][td][/td][td][/td][td]Column A[/td][td]Column B[/td][td]Column C[/td][td][/td][/tr]

[tr][td]

3​

[/td][td]customer id[/td][td]customer age[/td][td][/td][td][/td][td]customer id[/td][td][/td][td]transaction[/td][td][/td][/tr]

[tr][td]

4​

[/td][td]

22691​

[/td][td]

24​

[/td][td][/td][td][/td][td]

22691​

[/td][td][/td][td]Product A[/td][td]

24​

[/td][/tr]

[tr][td]

5​

[/td][td]

23498​

[/td][td]

46​

[/td][td][/td][td][/td][td]

22691​

[/td][td][/td][td]Product B[/td][td]

24​

[/td][/tr]

[tr][td]

6​

[/td][td]

23915​

[/td][td]

48​

[/td][td][/td][td][/td][td]

22691​

[/td][td][/td][td]Product C[/td][td]

24​

[/td][/tr]

[tr][td]

7​

[/td][td]

30453​

[/td][td]

32​

[/td][td][/td][td][/td][td]

22691​

[/td][td][/td][td]Product B[/td][td]

24​

[/td][/tr]

[tr][td]

8​

[/td][td]

30645​

[/td][td]

50​

[/td][td][/td][td][/td][td]

23498​

[/td][td][/td][td]Product B[/td][td]

46​

[/td][/tr]

[tr][td]

9​

[/td][td]

31304​

[/td][td]

46​

[/td][td][/td][td][/td][td]

23915​

[/td][td][/td][td]Product B[/td][td]

48​

[/td][/tr]

[tr][td]

10​

[/td][td]

33998​

[/td][td]

22​

[/td][td][/td][td][/td][td]

30453​

[/td][td][/td][td]Product A[/td][td]

32​

[/td][/tr]

[tr][td]

11​

[/td][td]

34063​

[/td][td]

70​

[/td][td][/td][td][/td][td]

23915​

[/td][td][/td][td]Product C[/td][td]

48​

[/td][/tr]

[tr][td]

12​

[/td][td][/td][td][/td][td][/td][td][/td][td]

23915​

[/td][td][/td][td]Product C[/td][td]

48​

[/td][/tr]

[tr][td]

13​

[/td][td][/td][td][/td][td][/td][td][/td][td]

33998​

[/td][td][/td][td]Product C[/td][td]

22​

[/td][/tr]

[tr][td]

14​

[/td][td][/td][td][/td][td][/td][td][/td][td]

30645​

[/td][td][/td][td]Product A[/td][td]

50​

[/td][/tr]

[tr][td]

15​

[/td][td][/td][td][/td][td][/td][td][/td][td]

31304​

[/td][td][/td][td]Product A[/td][td]

46​

[/td][/tr]

[tr][td]

16​

[/td][td][/td][td][/td][td][/td][td][/td][td]

33998​

[/td][td][/td][td]Product A[/td][td]

22​

[/td][/tr]

[tr][td]

17​

[/td][td][/td][td][/td][td][/td][td][/td][td]

34063​

[/td][td][/td][td]Product B[/td][td]

70​

[/td][/tr]
[/table]
H4=IF(E4="","",INDEX(B:B,MATCH(E4,A:A,0)))
copied down

 

[Covaism]

Thank you it looks complex Ill let you know if it works

 

[Covaism]

not working circular something any thing else

 

[AhoyNC]

Try VLOOKUP.
Change ranges to match your data.

Excel Workbook
	A	B	C
1	customer id	Age	transaction
2	22691	24	Product A
3	22691	24	Product B
4	22691	24	Product C
5	22691	24	Product B
6	23498	46	Product B
7	23915	48	Product B
8	30453	32	Product A
9	23915	48	Product C
10	23915	48	Product C
11	33998	22	Product C
12	30645	50	Product A
13	31304	46	Product A
14	33998	22	Product A
15	34063	70	Product B
Sheet2

Excel Workbook
	A	B
1	customer id	customer age
2	22691	24
3	23498	46
4	23915	48
5	30453	32
6	30645	50
7	31304	46
8	33998	22
9	34063	70
Sheet1

 

[FDibbins]

not working circular something any thing else

If you are getting a circular ref error, then you are putting the formula inside 1 of the ranges that it is using. Put the formula in a different cell (off to the side)(

 

[Covaism]

What would it be with these columns? and G needed to be filled?
*

	f	g	h

<tbody>
[TD="bgcolor: #cacaca, align: center"]1[/TD]
[TD="bgcolor: #c0c0c0, align: center"]customer id[/TD]
[TD="bgcolor: #c0c0c0, align: center"]Age[/TD]
[TD="bgcolor: #c0c0c0, align: center"]transaction
[/TD]

[TD="bgcolor: #cacaca, align: center"]2[/TD]
[TD="align: center"]22691[/TD]
[TD="align: center"]
Product AProduct A
[/TD]

[TD="bgcolor: #cacaca, align: center"]3[/TD]
[TD="align: center"]22691[/TD]
[TD="align: center"]24
[/TD]
[TD="align: center"]Product B
[/TD]

[TD="bgcolor: #cacaca, align: center"]4[/TD]
[TD="align: center"]22691[/TD]
[TD="align: center"]24[/TD]
[TD="align: center"]Product C[/TD]

[TD="bgcolor: #cacaca, align: center"]5[/TD]
[TD="align: center"]22691[/TD]
[TD="align: center"]24[/TD]
[TD="align: center"]Product B[/TD]

[TD="bgcolor: #cacaca, align: center"]6[/TD]
[TD="align: center"]23498[/TD]
[TD="align: center"]46[/TD]
[TD="align: center"]Product B
[/TD]

[TD="bgcolor: #cacaca, align: center"]7[/TD]
[TD="align: center"]23915[/TD]
[TD="align: center"]48[/TD]
[TD="align: center"]Product B
[/TD]

[TD="bgcolor: #cacaca, align: center"]8[/TD]
[TD="align: center"]30453[/TD]
[TD="align: center"]32[/TD]
[TD="align: center"]Product A[/TD]

[TD="bgcolor: #cacaca, align: center"]9[/TD]
[TD="align: center"]23915[/TD]
[TD="align: center"]48[/TD]
[TD="align: center"]Product C[/TD]

[TD="bgcolor: #cacaca, align: center"]10[/TD]
[TD="align: center"]23915[/TD]
[TD="align: center"]48[/TD]
[TD="align: center"]Product C[/TD]

[TD="bgcolor: #cacaca, align: center"]11[/TD]
[TD="align: center"]33998[/TD]
[TD="align: center"]22[/TD]
[TD="align: center"]Product C[/TD]

[TD="bgcolor: #cacaca, align: center"]12[/TD]
[TD="align: center"]30645[/TD]
[TD="align: center"]50[/TD]
[TD="align: center"]Product A[/TD]

[TD="bgcolor: #cacaca, align: center"]13[/TD]
[TD="align: center"]31304[/TD]
[TD="align: center"]46[/TD]
[TD="align: center"]Product A[/TD]

[TD="bgcolor: #cacaca, align: center"]14[/TD]
[TD="align: center"]33998[/TD]
[TD="align: center"]22[/TD]
[TD="align: center"]Product A[/TD]

[TD="bgcolor: #cacaca, align: center"]15[/TD]
[TD="align: center"]34063[/TD]
[TD="align: center"]70[/TD]
[TD="align: center"]Product B[/TD]

</tbody>

Spreadsheet Formulas

Cell Formula B2 =IF(A2="","",VLOOKUP(A2,Sheet1!$A$2:$B$7000,2,0)) <tbody> </tbody>

<tbody>
</tbody>

Excel tables to the web >> Excel Jeanie Html" target="_blank"> Excel Jeanie HTML 4

Sheet1

*	A	B

<colgroup><col style="font-weight:bold; width:30px; "><col style="width:82px;"><col style="width:104px;"></colgroup><tbody>
[TD="bgcolor: #cacaca, align: center"]1[/TD]
[TD="bgcolor: #c0c0c0, align: center"]customer id[/TD]
[TD="bgcolor: #c0c0c0, align: center"]customer age[/TD]

[TD="bgcolor: #cacaca, align: center"]2[/TD]
[TD="align: center"]22691[/TD]
[TD="align: center"]24[/TD]

[TD="bgcolor: #cacaca, align: center"]3[/TD]
[TD="align: center"]23498[/TD]
[TD="align: center"]46[/TD]

[TD="bgcolor: #cacaca, align: center"]4[/TD]
[TD="align: center"]23915[/TD]
[TD="align: center"]48[/TD]

[TD="bgcolor: #cacaca, align: center"]5[/TD]
[TD="align: center"]30453[/TD]
[TD="align: center"]32[/TD]

[TD="bgcolor: #cacaca, align: center"]6[/TD]
[TD="align: center"]30645[/TD]
[TD="align: center"]50[/TD]

[TD="bgcolor: #cacaca, align: center"]7[/TD]
[TD="align: center"]31304[/TD]
[TD="align: center"]46[/TD]

[TD="bgcolor: #cacaca, align: center"]8[/TD]
[TD="align: center"]33998[/TD]
[TD="align: center"]22[/TD]

[TD="bgcolor: #cacaca, align: center"]9[/TD]
[TD="align: center"]34063[/TD]
[TD="align: center"]70[/TD]

</tbody>

 

[FDibbins]

Just change the ranges that I gave you...
=INDEX(B:B,MATCH(F2,A:A,0))

 

[Covaism]

You are a GENIUS THANK YOU THANK YOU! I thought I was sleeping at my desk!

 

[FDibbins]

To whom was that directed?