vlookup

[tc]

i have two sheets, one has a list of names and corresponding
amounts.
the other sheet contains a second list of names and amounts in the
next two columns. Some of the names are appearing in the first list.
i
need to create a macro which will scan through the two sheets, and
if
the same name is in the two list then i want those names to appear
on
the third sheet and in the next three columns i want the amounts
from
the first list and the amounts from the second and third columns of
the second sheet.

 

[Norman Jones]

Hi TC,

See Chip Pearson at:

Duplicate And Unique Items In Lists
http://www.cpearson.com/excel/duplicat.htm#HighlightingDuplicates

See particularly the section entitled:

Extracting Values Common To Two Lists