Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I extract a second data in a Lookup
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
HOW TO EXTRACT (or lookup) DATA FROM A PIVOT TABLE | New Users to Excel | |||
data extract | Excel Worksheet Functions | |||
AGAIN... I need another Lookup Function to extract some data | Excel Worksheet Functions | |||
How to extract the data | Excel Worksheet Functions | |||
Extract Data | Excel Discussion (Misc queries) |