Sub-Total and VLookup problems

C

caddyin

I have correctly set up both sub-total and Vlookups in various spreadsheets,
but these functions are not working properly. The sub-totals (using sum
function) adds to zero, and the vlookups do not recognize matches that I know
exist. I've consulted many people, and all do not have an answer. Can you
help?
 
F

Frank Kabel

Hi
sounds like an format issue. Probably your values are actually text.
What does the following formula return
=ISNUMBER(A1)

Where A1 is one of your value cells

Also if you think you have a match check it directly with
=A1=X1
and see if this formula really returns TRUE.
 
Top