If And Or Statement Help

[RoscoW88]

Good Afternoon,

I am in need of some assistance with a formula for the below.

I need a formula to reproduce the results in the Formula column below

Part	Loc1	Loc2	Formula
1	A	1	Both
2		2	Loc2
3			BLANK
4	C		Loc1

any help is greatly appreciated

thanks
ross

[Olly]

Use:

=CHOOSE(COUNTA($B2:$C2)+1,"BLANK",IF($B2="",C$1,B$1),"Both")

[Sam Capricci]

this should work...
=IF(AND(B2="",C2=""),"BLANK",IF(AND(B2="",C2<>""),"Loc2",IF(AND(B2<>"",C2<>""),"Both","Loc1")))

[RoscoW88]

Thanks Olly & Sambo Kid!

Olly, i forgot to mention that i have a VLOOKUp on the cells in columns, my mistake!

But SamboKid's formula does the trick!

Thanks Both.

[Olly]

That's the problem with only sharing text, instead of an actual workbook...

EDIT: here's an alternative, which works with formulae in B:C;

=CHOOSE(COUNTBLANK($B2:$C2)+1,"Both",IF($B2="",$C$1,$B$1),"BLANK")