simple condition - if A1=A2 then B1=B2

morag

New Member
Joined
Jan 13, 2005
Messages
20
Should be strightforward, but having mental block today.

I have 2 columns. Column A always has a value. Every second field in ColumnB is blank.

A1: = 25 B1: = <blank>
A2: = 25 B2: = 100
A3: = 30 B3: = <blank>
A4: = 30 B4: = 128

I want to copy the value in B2 to B1 if A2 equals A1.

Thanks for any help.
 

Some videos you may like

Excel Facts

Why does 9 mean SUM in SUBTOTAL?
It is because Sum is the 9th alphabetically in Average, Count, CountA, Max, Min, Product, StDev.S, StDev.P, Sum, VAR.S, VAR.P.

Andrew Poulsom

MrExcel MVP
Joined
Jul 21, 2002
Messages
73,092
Click the header for column B and choose Edit|Go To|Special Blanks. In the Formula Bar type:

=IF(A1=A2,B2,"")

hold down Ctrl and press Enter.
 

morag

New Member
Joined
Jan 13, 2005
Messages
20
Just came back to say I'd remembered. But you guys are quick. Thanks. :biggrin:
 

Watch MrExcel Video

Forum statistics

Threads
1,119,127
Messages
5,576,235
Members
412,709
Latest member
AD04
Top