I'm trying to create my own credit card analyzer and I saw one close to what
I want and it had a worksheet that had all the merchants listed in column
"A" this workbook had 3 worksheets in it, the main one was where the credit
card data is entered. in the formula column it had this
=IF(COUNTIF(StoreList,B2),B2,"Other") I want to understand how this formula
tells the main worksheet to use data from the merchant worksheet.

Thanks