VLOOKUP In EXCEL

	A	B	C	D	E	F	G	H	I	J
1		NO	NAME	PRIZE				NO	NAME	PRIZE
2		1	BOLT	100000				4	LEWIS	15000
3		2	REGIS					3	BLAKE	50000
3		3	BLAKE					1	BOLT	100000
4		4	LEWIS					2	REGIS	20000
5		5	POWELL					5	POWELL	25000

FORMULAS:

PASTE THIS FORMULA IN D2 CELL.

=VLOOKUP(B2,H:J,3,FALSE)