View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.newusers
DP DP is offline
external usenet poster
 
Posts: 58
Default using another file for vlookup

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