I have a data that contains employee numbers and amount earned as bonus. Some
of the employees earn bonuses from one or two schemes. When I use VLOOKUP to
extract data, the expression only picks the first amount that is found in the
database. How can I go about it so that the second number of the same
employee will pick the second amount?

Extract from database
Emp# Amt
MC5604 $20
MC5604 $50

Current result
Emp# Amt
MC5604 $20
MC5604 $20

Expected result
Emp# Amt
MC5604 $20
MC5604 $50

Thank you

Darkwah