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

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

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