Match list to multi-format range?

[mohamme]

I'm trying to check if text within a column is contained within a range of cells that has both General and Currency formats.

I've created a workbook to summarize inventory value. Each row has customer name, part number, quantity in house, the part value, and the total value for that part. This means I have multiple duplicate entries for customer names. On a seperate sheet, I set up subtotals by customer, with the most common customers already typed in manually. There are a number of blank spaces to type in other customers, and the subtotal will fill in automatically. The subtotal value in the cell beneath it uses SUMIF based on the customer name typed above, pulling data from original sheet.

Basically, I'd like to make sure all customers on the original sheet have a subtotal on the other sheet, with a warning telling me if not. Even just a TRUE/FALSE would work. I'm at a loss. I'd like it to all be automatic, but I'm not sure if it is possible. I can't seem to get MATCH or EXACT to work, and I'm pretty new to Excel so I don't know what else to try. Thanks in advance.

[NBVC]

If you have a list of unique customers in say Sheet3, and the database of customers is in Sheet1, column A, then try:

=ISNUMBER(MATCH(A2,'Sheet1'!A:A,0))

copied down

This returns TRUE if an identical match is found, and FALSE if not.

Is that what you are looking for?

[mohamme]

The problem there, is that the customer in-house list is frequently changing, so a complete list will give me false values, because they are not listed. I'm making this for somebody else, and so even pulling the customer list from first sheet, then filtering it to only show unique values is probably too much for them. If that is the only way, I should be able to do that, but I'd like to make it automatic.

[NBVC]

If you convert the list with my formula to a table (INSERT|TABLE), then when you add a new customer the formula will automatically follow along... same if you remove a customer.....

any more automatic than that, you need VBA I think....