All that formula is doing is counting the number of times the value in B2
occurs in the named range StoreList. If the count is greater than zero, it
returns the value in cell B2. If the count is zero, it returns "Other". Some
other formula may be using the result the formula returns to use data from
the merchant worksheet.

"Just Me" wrote in message
...
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