View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Alberta Rose Alberta Rose is offline
external usenet poster
 
Posts: 54
Default V Lookup between worksheets in same file


I'm trying to sum quarterly hours depending on employee name. Employee name
resides in column A of each worksheet. I have name defined the areas on the
sheets where the data resides as APR MAY JUN.

=vlookup(A5, Apr:Jun - what's next????

I want excel to look at the name in cell A5 on each sheet and if there is a
match, go to cell B5 and sum, C5, D5, etc. etc.

How do I do this? Help please...

Thanks, Laurie