vlookup / Indexing

[cmcclean]

I'm looking for a function to populate column 'Hold1'.
If a value in Ref2 is present in Ref1, then populate Hold1 with the corresponding value in Hold2

Ref1	Hold1		Ref2	Hold2
15			5	35
21			23	2
58			56	16
23			15	9
2			87	25
10			60	1
89			65	13
95
34
65
15
9
22

<tbody>
</tbody>

The completed table will look like this:

Ref1	Hold1		Ref2	Hold2
15	9		5	35
21	0		23	2
58	0		56	16
23	2		15	9
2	0		87	25
10	0		60	1
89	0		65	13
95	0
34	0
65	13
15	9
9	0
22	0

<tbody>
</tbody>

 

[Fluff]

Try

Excel 2013/2016
	A	B	C	D	E
1	Ref1	Hold1		Ref2	Hold2
2	15	9		5	35
3	21	0		23	2
4	58	0		56	16
5	23	2		15	9
6	2	0		87	25
7	10	0		60	1
8	89	0		65	13
9	95	0
10	34	0
11	65	13
12	15	9
13	9	0
14	22	0
Sheet2

Cell Formulas
Range	Formula
B2	=IFERROR(INDEX($E$2:$E$8,MATCH(A2,$D$2:$D$8,0)),0)

 

[cmcclean]

Worked perfectly. Thanks

 

[Fluff]

You're welcome & thanks for the feedback