Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
comparing lists - i think
i have a column of names & another 'master' column of these and many more
names with a no. i need to find the no. from the master column to match with the name in the first column basically i need to end up with just the first list and the appropriate no. what would be the easiest way to do this |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
comparing lists - i think
Try e.g. this, =VLOOKUP(A1,C:D,2,FALSE) Put this formula to the right of each name in the first list. 1. argument (A1) is reference to the name in the first list. 2. arg. (C:D) is the "master columns" containing names and numbers, either on a separate place in the first list, or another sheet in the same workbook. 3. arg. (2) is the place in the "master" where the result is. 4. arg. (FALSE), only exact matches will be given. -- ~roar xeno skrev: i have a column of names & another 'master' column of these and many more names with a no. i need to find the no. from the master column to match with the name in the first column basically i need to end up with just the first list and the appropriate no. what would be the easiest way to do this |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
comparing lists - i think
thanking you roar, that worked perfectly
cheers, Xeno "Roar" wrote: Try e.g. this, =VLOOKUP(A1,C:D,2,FALSE) Put this formula to the right of each name in the first list. 1. argument (A1) is reference to the name in the first list. 2. arg. (C:D) is the "master columns" containing names and numbers, either on a separate place in the first list, or another sheet in the same workbook. 3. arg. (2) is the place in the "master" where the result is. 4. arg. (FALSE), only exact matches will be given. -- ~roar xeno skrev: i have a column of names & another 'master' column of these and many more names with a no. i need to find the no. from the master column to match with the name in the first column basically i need to end up with just the first list and the appropriate no. what would be the easiest way to do this |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Comparing lists | Excel Worksheet Functions | |||
Comparing two lists in excel that don't match exactly | Excel Worksheet Functions | |||
Comparing lists of map references | Excel Worksheet Functions | |||
Comparing multiple lists | Excel Worksheet Functions | |||
Comparing 2 Customer Lists to Identify Shared Customers | Excel Worksheet Functions |