Excel 2010 ISBLANK Function

[AG5280]

Hi -

First time poster with probably a very simple question about the use of "ISBLANK".

I have 2 columns of data (A:A), (B:B) with text values in them.

At any time either A1 is filled in and B1 is blank, or A1 is blank and B1 is filled in or both are filled in with the same value, or both are blank.

In Column C, I'd like to use the ISBLANK function for the following objectives:

1) If A1 contains a value but B1 is blank, place value of A1 in C1
2) If A1 is blank and B1 contains a value, place value of B1 in C1
3) If A1 and B1 both contain values, which they will always be the same, place that value in C1
4) If both A1 and B1 are blank, place "Fusion Direct" in C1

Will the ISBLANK function accomplish this goal, or do I need to utilize something else?

Thank you,
AG

 

[RoryA]

Are the values numbers?

 

[AG5280]

Hi there - the values are always text, our business unit proper names.

 

[Jonmo1]

Welcome to the board...

Try this in C1

=LOOKUP("zz",CHOOSE({1,2,3},"Fusion Direct",A1,B1))


Hope that helps.

 

[AG5280]

WOW! Thank you SO MUCH JONMO1 - That was awesome, and helped out perfectly!

 

[AG5280]

Thank you also Jon I appreciate the help!

 

[Jonmo1]

Glad to help..
Thanks for the feedback.

I think the other Jon's is just as good if you have XL2007 or later.

 

[Jon von der Heyden]

I was a bit slow so I deleted it after I saw Jonmo's reply as there was little difference between them.