J
Jambruins
This is the data in cells T, U, and V in the tab called ODDS(Archives)
BOS NYY 3-Apr
PIT MIL 4-Apr
CIN NYM 4-Apr
PHI WAS 4-Apr
BOS NYY 4-Apr
This goes on all the way to row 5000.
In my tab called BOS I have cell A2 with the following formula in it:
=VLOOKUP(A1,'ODDS (Archives)'!T:V,3,0). This gives me the value 3-Apr which
is what I want. I would like cell A3 to find the next occurance of BOS and
then display the value from cell V (which would be 4-Apr). I would cells,
A4, A5, etc. to keep doing this. Any idea how to do this? Thanks
BOS NYY 3-Apr
PIT MIL 4-Apr
CIN NYM 4-Apr
PHI WAS 4-Apr
BOS NYY 4-Apr
This goes on all the way to row 5000.
In my tab called BOS I have cell A2 with the following formula in it:
=VLOOKUP(A1,'ODDS (Archives)'!T:V,3,0). This gives me the value 3-Apr which
is what I want. I would like cell A3 to find the next occurance of BOS and
then display the value from cell V (which would be 4-Apr). I would cells,
A4, A5, etc. to keep doing this. Any idea how to do this? Thanks