SUBTOTAL function

[DKoinonia]

I don't know how much or how little to explain about my file, so please forgive me if I err in either direction.

My company has some confusing rules concerning which warehouse each inventory item belongs. My intent is to create a tool for other users so that they don't have to call my department so often to see whether they picked the right warehouse for their transaction. When the user successfully selects all of their criteria (i.e., columns B through G), the resulting warehouse should appear in the black box atop the page.

To do this, I am using an autofilter, several subtotal functions, and hidden columns. Long-story short, I cannot include macros or any functions that are not available in Excel 2003. I have made all of the data rows white text since I don't want the users to have a cluttered view...they merely have to select their criteria. [Please feel free to change the text color as desired, obviously.] As the user begins to make their choices, I want a "flag" (i.e., a check mark in this case) to appear atop the column so that they know that criteria is complete. Sometimes one selection will fulfill multiple criteria.

So, what's the problem, you say?

One of the SUBTOTAL functions is not returning the correct value for the check-mark feature. All results for SUBTOTAL(9,___) of the columns I through N return a value of zero, and I cannot figure out why.

[bentleybob]

Unfortunately, excel sees the SUBTOTAL function in your VLOOKUP and considers it a nested subtotal, and therefore ignores it.