Here's my problem. I have:
A B C
Customer Contract OpenDate
1 5055 Bats 11/15/05
2 6100 Balls 08/17/04
3 6100 Bats 06/16/05
4 8750 Hats 12/01/05
I've got a vlookup that will pick up the first instance of 6100 and it's open date. To pick up the second instance of 6100, I came up with this formula after reviewing similar posts on this site:
=VLOOKUP(INDEX($A$1:$C$4,MATCH(A3,$A$1:$A$4,1)+1,1),$A$1:$C$4,3,FALSE)
but the results are for 8750! It's like it's MATCH-ing the second instance of 6100 instead of the 1st! Arg!!!!! Can anyone twll me what I'm overlooking?
A B C
Customer Contract OpenDate
1 5055 Bats 11/15/05
2 6100 Balls 08/17/04
3 6100 Bats 06/16/05
4 8750 Hats 12/01/05
I've got a vlookup that will pick up the first instance of 6100 and it's open date. To pick up the second instance of 6100, I came up with this formula after reviewing similar posts on this site:
=VLOOKUP(INDEX($A$1:$C$4,MATCH(A3,$A$1:$A$4,1)+1,1),$A$1:$C$4,3,FALSE)
but the results are for 8750! It's like it's MATCH-ing the second instance of 6100 instead of the 1st! Arg!!!!! Can anyone twll me what I'm overlooking?