If Cell H is blank then return value

[mdonovan890]

I am trying to get a formula so that if cell H is blank then return the information from cell B. For Example H2 is blank I would like Credit One to be the returned value in Cell B35. I was thinking a count if formula but I am having trouble getting it to pull the correct data.

 

[SQUIDD]

like this??

=IF(H2="",B2,"")

not sure if I understood correctly?

Dave

 

[LPhan]

I am trying to get a formula so that if cell H is blank then return the information from cell B. For Example H2 is blank I would like Credit One to be the returned value in Cell B35. I was thinking a count if formula but I am having trouble getting it to pull the correct data.

In cell I2:
=if(isblank(H2),B2,A2)

drag down for the rest of the cells. Unfortunately you'd have to do it on column I and hide column H or something, otherwise you'll get circular reference errors

 

[dUBBINS]

Put this in B35:

IF(H2="","Credit One","")

But I also am not entirely sure if I understand what you are asking for.

 

[mdonovan890]

thank you!