View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
excel excel is offline
external usenet poster
 
Posts: 16
Default Finding 'total' in range

I have a block of data (say A1:P40) and in that range, I have named 2
ranges. A1:A40 is named "Name" and P1:P40 is named Total. What I
need is to be able to put the corresponding "Total" for Jeremy (one of
the "Name" range) when Jeremy's name is put elsewhere in the
workbook. If George is put, then George's total will be there.
Name in "Name" range will only appear once.

Any help?


TIA
Esra