Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Vlookup
I am trying to find two different types of data that come from the same
person. For Example: Name ID Date In Date Out Adam 001234 12/12/07 12/11/08 Adam 001234 12/12/08 12/11/09 I need to use the ID number as the lookup value. When I use =Vlookup to find the date out for Adam I can only get the first one, 12/11/08. I am assuming it is because they are the same number, but is there any way to use the second ID number in the column to get the second date, 12/11/09? Thanks |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
VLookUp - Does the VLookUp return the exact information? | Excel Worksheet Functions | |||
Vlookup in vlookup - taking the result as array name | Excel Worksheet Functions | |||
Combine VLOOKUP and IF function so #NA isn't returned as a value from VLOOKUP | Excel Discussion (Misc queries) | |||
Vlookup -=VLOOKUP(F9,LookUp1!$A$2:$B$1504,2,FALSE) | New Users to Excel | |||
Vlookup info being used without vlookup table attached? | Excel Worksheet Functions |