Help with a formula - probably an "IF"

[Buffgirl71]

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.

 

[JE McGimpsey]

One way:

B2: =IF(A2<>"", A2, B1)

Copy down as far as necessary.

 

[Buffgirl71]

That doesn't work in this example, because the number of blank rows
isn't consistent; I need to pull back the value only when the value in
column A is literally "2", and I need to pull back the data for the row
immediately preceding that is a "2". Thanks for your help.

 

[Trevor Shuttleworth]

Try

=IF(A2=2,B2,C1)

Regards

Trevor

 

[JE McGimpsey]

Ah, I didn't parse your example correctly.

I'm still not sure how you get your value if the column A value =2.

If you have to enter it manually, it seems like

B2: =B1

copied down will suffice, right?

A B
1 2 1212
2 3 =B1
3 4 =B2
4 4 =B3
5 2 3434
6 3 =B5
7 4 =B6

....

 

[Buffgirl71]

That worked perfectly. Thanks so much.