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)