Thread: Lookup
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Ananth Ananth is offline
external usenet poster
 
Posts: 51
Default Lookup

A B C D E F G
Project Jan Feb Mar Apr May Total
A1 2 3 4 5 6 20
A2 2 4 6 8 20
A3 7 9 16
A4 10 10



Summary

A B C

Total Savings Starting Month
A1 20 Jan
A2 20 Feb
A3 16 Apr
A4 10 May


Colm B to F show month data, while data under COLM A show project names

When I create the summary report,I want a formula that will show the First
month under Colmn C, when savings start, I am dealing with rougly 2000
projects spread over in 120 Locations.

Any help please