Thread: Lookup
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Smooney Smooney is offline
external usenet poster
 
Posts: 24
Default Lookup

I have a workbook that contains 27 worksheets with 20 columns and 120 rows
each. Column D in each worksheet contains a different name in each row and
Column L in each worksheet contains a different # assosiated with the name in
Column D.

On a separate 'Totals' worksheet, I need the person's name and the sum of
all #'s from Column L assosiated with that name from all worksheets. The
names are all in different rows in each worksheet.

Please help!