I need a formula

[Guest]

HI,al
please hel

a1 To
a2 Ji
a3 And

b1 Lis

I need a formula, make c1 = "a" when I can find b1 in a1:a3 , otherwise, c1="b
thanks

 

[Norman Harker]

Hi monker!

One way:
=IF(COUNTIF($A$1:$A$3, B1)>0,"a","b")

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.

 

[Leo Heuser]

Hi monker

In C1:

=IF(COUNTIF(A1:A3,B1),"a","b")

 

[Ken]

Norman,

I'm "lurking" trying to learn Excel. I follow most of this formula but why
is the >0 necessary?

Thank you,
Ken

 

[Frank Kabel]

Hi Ken
in this case the '>0' part is not required. i think Norman added it
just for clarification

 

[Ken]

Thank you Frank. Wish I had more time to spend here. VERY interesting to me.

Ken

 

[CLR]

=IF(ISNA(VLOOKUP(B1,A1:A3,1,FALSE)),"B","A")

Vaya con Dios,
Chuck, CABGx3