Formula

  • Thread starter Thread starter Matthew
  • Start date Start date
M

Matthew

YE2002 1Q03 2Q03 3Q03 4Q03

Matt 5 6 7 8 9
Steve 2 3 4 5 7
John 4 5 6 7 6
Fred 1 2 3 4 5
Jane 7 6 5 4 4
Joe 6 5 4 3 3


NEXT TAB
Recent Qtr
2Q03
Steve
John
Jane


What formula can I use so that the recent qtr column gets
filled in? Then when I change the Recent Qtr to 3Q03, it
automatically updates with those numbers.
 
Matthew

=VLOOKUP($A3,Sheet1!$A$3:$F$8,MATCH($B$2,Sheet1!$B$1:$F$1,0)+1,FALSE)

$A3 is the cell containing the name to be looked up
Sheet1!$A$3:$F$8 is the range containing the data ie.
5 6 7 8 9
2 3 . . .
..
$B$2 is the cell containing the quarter ie(2Q03)
$B$1:$F$1 is the range containing the year & quarter names

Dan E
 
Back
Top