using another file for vlookup

  • Thread starter Thread starter dp
  • Start date Start date
D

dp

New user Excel 2003, Windows Professional 2000. I have a file 2900 rows but
just for 100 people - it repeats a name / code every entry. I want to use
this file for a vlookup on another file that just has a name and extract the
code. How do I reduce the 2900 rows to just 100. Hope I explained this
correctly.
tia
 
data/filter/advanced filter
check Unique values checkbox
Copy to another location, and speficy a new location on that sheet.
Use the results as your table for looking up values.
HTH
 
Perfect! Thanks for your time.

Bob Umlas said:
data/filter/advanced filter
check Unique values checkbox
Copy to another location, and speficy a new location on that sheet.
Use the results as your table for looking up values.
HTH
Click to expand...
 
Back
Top