I have cells that look like this, sorted in this order:
A1 B1 B2 What I want B2 to be

2 1212 1212
3 1212
4 1212
4 1212
4 1212
2 3434 3434
3 3434
4 3434
4 3434
2 0000 0000
3 0000
4 0000


In B2 I want the value of B1, if A2 = 2, for the "2" record just above
it (but not a consistent number of rows). I've shown what I want B2 to
be above. Thanks very much for any help you can give me with a formula.
If it's important, there is always one "2" record, one "3" record, and
any number of inconsistent "4" records.