Random Lookup for Excel

I want to do a random lookup on a list of data. I used Vlookup but that only returns the first cell that match. Please help to random select from the list.

Data: $A$1:$B$12

CHESSCY 3562908

CHESSCY 5917972

CHESSCY 9120332

CHESSCY 1034603

CHESSCY 7267341

MANCY 9344508

MANCY 7246578

MANCY 8598782

MANCY 3522520

MANCY 8062641

MANCY 9191026

Formula:

CHESSCY 3562908 >> =VLOOKUP(D1,$A$1:$B$12,2,FALSE)

CHESSCY 3562908 >> =VLOOKUP(D2,$A$1:$B$12,2,FALSE)

MANCY 9344508 >> =VLOOKUP(D4,$A$1:$B$12,2,FALSE)

MANCY 9344508 >> =VLOOKUP(D5,$A$1:$B$12,2,FALSE)