ExcelBanter - View Single Post - Lookup certain text within a cell, PLEASE HELP!

oldchippy

Wrote:
There is a source cell that can contain any combination of AA, BB, HH,
and other 2 letter text separated by commas.
For example cell A1 can have "AA, HH"
cell b2 can have "AA, BB, HH"
I want to set up a formula so that another cell can check cell a1 or
b2
and see if "AA" is found in that cell and if it does, to return a "1".
If the cell does not have "AA" in it then it would return a "0." Is
this at all possible? Thanks!
Hello asimpleman,

If your AA are always the left most characters, then if your item is in
A1

B1 should have this

=IF(LEFT(A1,2)="AA",1,0)

oldchippy :)

--
oldchippy
------------------------------------------------------------------------
oldchippy's Profile: http://www.excelforum.com/member.php...o&userid=19907
View this thread: http://www.excelforum.com/showthread...hreadid=569896