[TABLE="width: 913"]
<tbody>[TR]
[TD]The following is sample data:
The first column is the original data:
The second column is what I am getting when I use the formula in the third column. The fourth column is what I would like to get. I thought I understood nested iFs, but I am missing something. Thanks!
719 S ABERDEEN ST 1,CICERO IL
[/TD]
[TD]
CICERO[/TD]
[TD]
=IF(FIND("CICERO",B2),"CICERO",IF(FIND("CHICAGO",B2),"CHICAGO",""))[/TD]
[TD]
CICERO[/TD]
[/TR]
[TR]
[TD]1656 W HOWARD ST 1ST,CICERO IL[/TD]
[TD]CICERO[/TD]
[TD]=IF(FIND("CICERO",B3),"CICERO",IF(FIND("CHICAGO",B3),"CHICAGO",""))[/TD]
[TD]CICERO[/TD]
[/TR]
[TR]
[TD]700 N GREEN ST 3RD 304,CHICAGO IL[/TD]
[TD="align: center"]#VALUE![/TD]
[TD]=IF(FIND("CICERO",B8),"CICERO",IF(FIND("CHICAGO",B8),"CHICAGO",""))[/TD]
[TD]CHICAGO[/TD]
[/TR]
[TR]
[TD]11 E ILLINOIS ST,CHICAGO IL[/TD]
[TD="align: center"]#VALUE![/TD]
[TD]=IF(FIND("CICERO",B9),"CICERO",IF(FIND("CHICAGO",B9),"CHICAGO",""))[/TD]
[TD]CHICAGO[/TD]
[/TR]
[TR]
[TD]1008 W LAKE ST 1ST,CHICAGO IL[/TD]
[TD="align: center"]#VALUE![/TD]
[TD]=IF(FIND("CICERO",B10),"CICERO",IF(FIND("CHICAGO",B10),"CHICAGO",""))[/TD]
[TD]CHICAGO[/TD]
[/TR]
[TR]
[TD]113-125 N GREEN ST BSMT - 6TH,SPRINGFIELD IL[/TD]
[TD="align: center"]#VALUE![/TD]
[TD]=IF(FIND("CICERO",B14),"CICERO",IF(FIND("CHICAGO",B14),"CHICAGO",""))[/TD]
[TD]OTHER[/TD]
[/TR]
</tbody>[/TABLE]
<tbody>[TR]
[TD]The following is sample data:
The first column is the original data:
The second column is what I am getting when I use the formula in the third column. The fourth column is what I would like to get. I thought I understood nested iFs, but I am missing something. Thanks!
719 S ABERDEEN ST 1,CICERO IL
[/TD]
[TD]
CICERO[/TD]
[TD]
=IF(FIND("CICERO",B2),"CICERO",IF(FIND("CHICAGO",B2),"CHICAGO",""))[/TD]
[TD]
CICERO[/TD]
[/TR]
[TR]
[TD]1656 W HOWARD ST 1ST,CICERO IL[/TD]
[TD]CICERO[/TD]
[TD]=IF(FIND("CICERO",B3),"CICERO",IF(FIND("CHICAGO",B3),"CHICAGO",""))[/TD]
[TD]CICERO[/TD]
[/TR]
[TR]
[TD]700 N GREEN ST 3RD 304,CHICAGO IL[/TD]
[TD="align: center"]#VALUE![/TD]
[TD]=IF(FIND("CICERO",B8),"CICERO",IF(FIND("CHICAGO",B8),"CHICAGO",""))[/TD]
[TD]CHICAGO[/TD]
[/TR]
[TR]
[TD]11 E ILLINOIS ST,CHICAGO IL[/TD]
[TD="align: center"]#VALUE![/TD]
[TD]=IF(FIND("CICERO",B9),"CICERO",IF(FIND("CHICAGO",B9),"CHICAGO",""))[/TD]
[TD]CHICAGO[/TD]
[/TR]
[TR]
[TD]1008 W LAKE ST 1ST,CHICAGO IL[/TD]
[TD="align: center"]#VALUE![/TD]
[TD]=IF(FIND("CICERO",B10),"CICERO",IF(FIND("CHICAGO",B10),"CHICAGO",""))[/TD]
[TD]CHICAGO[/TD]
[/TR]
[TR]
[TD]113-125 N GREEN ST BSMT - 6TH,SPRINGFIELD IL[/TD]
[TD="align: center"]#VALUE![/TD]
[TD]=IF(FIND("CICERO",B14),"CICERO",IF(FIND("CHICAGO",B14),"CHICAGO",""))[/TD]
[TD]OTHER[/TD]
[/TR]
</tbody>[/TABLE]