"if function" return value based on 2 adjacent cells

[MrDeals]

Hi,

I am trying use a "if function" to return value based on 2 adjacent cells and drag it down all the way till the next matching data.

i.e. If column B matches "Customer ID:" then display the code

with this formula =IF(B:B="Customer ID:",C:C,"")
I am able to do only on the same row, how can I drag it down to the next rows?

Thank You

 

[Rick Rothstein]

You don't put full column references, rather, you put exact cell addresses (without $ signs) and Excel will automatically increment the cell reference as you drag the formula. So, for what you showed us, put this formula in cell A2 and drag it down...

=IF(B2="Customer ID:",C2,"")

 

[rasinc]

Sorry to intrude Rick but I read the OP's request a bit different. To me it looked like the OP needed the customer ID on each row similar to a GoTo Blanks and copy the customer ID down if the ID was already in Column A as indicated.

In this case I would use

=IF(B2="Customer ID:",C2,A1)

and copy that down.

 

[MrDeals]

Sorry to intrude Rick but I read the OP's request a bit different. To me it looked like the OP needed the customer ID on each row similar to a GoTo Blanks and copy the customer ID down if the ID was already in Column A as indicated.

In this case I would use

=IF(B2="Customer ID:",C2,A1)

and copy that down.

rasinc Thank you, this works perfectly!

Rick Rothstein I appreciate your assistance as well.