Lookup
Assuming that on Sheet1, A1:G5 contains the data, and that on Sheet2,
A2:A5 contains A1, A2, A3, and A4, try the following formula which needs
to be confirmed with CONTROL+SHIFT+ENTER...
C2, copied down:
=INDEX(Sheet1!$B$1:$F$1,MATCH(TRUE,INDEX(Sheet1!$B $2:$F$5,MATCH(A2,Sheet1
!$A$2:$A$5,0),0)<"",0))
Adjust the ranges accordingly.
Hope this helps!
In article ,
Ananth wrote:
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
|