D
Darkwah
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
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