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 | CICERO | =IF(FIND("CICERO",B2),"CICERO",IF(FIND("CHICAGO",B2),"CHICAGO","")) | CICERO |
1656 W HOWARD ST 1ST,CICERO IL | CICERO | =IF(FIND("CICERO",B3),"CICERO",IF(FIND("CHICAGO",B3),"CHICAGO","")) | CICERO |
700 N GREEN ST 3RD 304,CHICAGO IL | #VALUE! | =IF(FIND("CICERO",B8),"CICERO",IF(FIND("CHICAGO",B8),"CHICAGO","")) | CHICAGO |
11 E ILLINOIS ST,CHICAGO IL | #VALUE! | =IF(FIND("CICERO",B9),"CICERO",IF(FIND("CHICAGO",B9),"CHICAGO","")) | CHICAGO |
1008 W LAKE ST 1ST,CHICAGO IL | #VALUE! | =IF(FIND("CICERO",B10),"CICERO",IF(FIND("CHICAGO",B10),"CHICAGO","")) | CHICAGO |
113-125 N GREEN ST BSMT - 6TH,SPRINGFIELD IL | #VALUE! | =IF(FIND("CICERO",B14),"CICERO",IF(FIND("CHICAGO",B14),"CHICAGO","")) | OTHER |
<tbody>
</tbody>